View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Daniel.C[_3_] Daniel.C[_3_] is offline
external usenet poster
 
Posts: 133
Default countif with multiple criteria

Try :
=SUMPRODUCT(((D1:D7=12)+(D1:D7=21)+(D1:D7=23)+(D1: D7=60))*(F1:F7="y"))
HTH
Daniel

I'd like to be able to count the number of "Y" in column H where the values
in column D are equal to 12, 21, 60 or 23.

Any ideas would be appreciated.