multiple criteria for count if

G

gtsch

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"),--(D5:D301="1"))

and only get 0 as an output

what am i doing wrong?
 
J

John James

Hi gtsch

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

Drop the double quotes and your formulae should work.
 
Top