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


"gtsch" wrote:

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?
--
gtsch