Thread
:
multiple criteria for count if
View Single Post
#
1
Posted to microsoft.public.excel.misc
gtsch
Posts: n/a
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
Reply With Quote