hi, to count the occurrences of multiple conditions, try to use sumproduct.

=sumproduct(--(a2:a100="condition 1")*(b2:b100="condition 2"))

hth
regards from Brazil
Marcelo

"Debi" escreveu:

In the help menu at the end of the formula there is 0,1 I do not know what
this is referencing could someone explain this to me please?