Counting Text Strings
=SUM(COUNTIF(A2:A100,{"string1","string2"}))
--
Regards,
Peo Sjoblom
"Kholm" wrote in message
...
How do I count the number of occurrences of two text strings in a range?
I
am compiling demographic information for my boss at work and need to know
the
number of caucasion males, caucasion females, etc. I have already created
the array formulas to count one text string in a range (i.e. number of
males
and females), but I do not know how to count two. Please help!
|