View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default multiple criteria in one field 4a,4b etc of countif?

=SUMPRODUCT(--(A1:A10={"5a","5b"}))



--

Regards,

Peo Sjoblom



"Anne-Marie" wrote in message
...
Now trying to do COUNTIF(A5:X5,"5a,5b") etc but it keeps telling me I have

an
error
More help would be appreciated.