multiple criteria for count if
 

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

multiple criteria for count if
 

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

multiple criteria for count if
 

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

multiple criteria for count if
 

thanks that did the trick

appreciate your help
--
gtsch


"tjtjjtjt" wrote:

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