Hi gtsch

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

Drop the double quotes and your formulae should work.

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


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=533980