Stupid me, if that works why not use

=COUNTIF(B2:B100,"White Male")

if you are using more than one column (the proper way to do it)


=SUMPRODUCT(--(A2:A100="White"),--(B2:B100=:Male"))


--
Regards,

Peo Sjoblom





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