So how are these setup? Are you using 2 columns or do you mean a single cell
can hold "White Male" (not a very good design to have it like that, next
time if possible use multiple cells)


=SUMPRODUCT(LEN(B2:B100)-LEN(SUBSTITUTE(LOWER(B2:B100),"white
male","")))/LEN("White Male")

might work



--
Regards,

Peo Sjoblom






"Kholm" wrote in message
...
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!