View Single Post
  #3   Report Post  
Biff
 
Posts: n/a
Default How do you count data that matches more than one condition?

Hi!

Try one of these:

=COUNTIF(A1:A10,"textA")+COUNTIF(A1:A10,"textB")

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:A10,{"textA","textB"},0))))

Biff

"ryesworld" wrote in message
...
Hi All:
I need a formula that will count the number of occurences that a column
contains either "text string A" or "text string B".