View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gtsch
 
Posts: n/a
Default 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