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