I'm not very knowledgable with Excel so I'm not sure how my data is
formatted.

The info I am trying to count is in 2 separate columns. One column is
labeled sex and the other is race.

Here is the array formula I am using to count single strings of text.
=SUM(LEN(B2:B100)-LEN(SUBSTITUTE(B2:B100,"Male","")))/LEN("Male")

"bj" wrote:

I think we need more info
how is your data formatted?
is the info you are looking for the only thing in a given cell or is it only
part of the cell?
What array formula are you currently using?

"Kholm" wrote:

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!