This formula is calculating the number of times white and male appears in the
range. However, I need to know how many times white and male appears
together in the range. Ex. the number of males who are also white.
How do I modify the formula to calculate this?

"Peo Sjoblom" wrote:


=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!