Hey guys,
I have this baseline and headcount parts in my sheet.
Baseline is for assigning the availability of a person per month and headcount should represent just a ONE or a ZERO, whether this person is assigned something (>0.1) or nothing (0) in the baseline.
I experimented with the sum-index-match formula in the headcount part, but was not successful to get the sum of my criteria and give as a result only a ONE or ZERO.
Please have a look in the attachment to understand what I mean…
Thanks.