Zero or One using Sum-index-match formula

  • 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…

  • Re: Zero or One using Sum-index-match formula [Solved]

    I am sorry for not responding quickly, but your solution was perfect! I only changed 0.1 to 0 (this was my mistake)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!