multiple criteria for count if

[Guest]

i am trying to count the number of rows over 90 in column c that also have a
1 in column d

i have tried
=SUMPRODUCT(--(C5:C301>="90"),--(D5301="1"))

and only get 0 as an output

what am i doing wrong?

 

[Guest]

This should work. Note there are no "".
=SUMPRODUCT(--(C5:C301>=90),--(D5301=1))

 

[John James]

Hi gtsch

="90" looks for text
whereas =90 looks for numbers

Drop the double quotes and your formulae should work.

 

[Guest]

thanks that did the trick

appreciate your help