View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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!