If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Royegg" wrote in message
...
I have a worksheet containing text items in multiple columns. Each row
represents an individual (n=189). I am trying to count the number of
individuals who have at least one instance of a particular text entry
(e.g.
Harm Reduction).

Now there are approximately 10 columns in which 'Harm Reduction' could
appear but not all individuals will have this text entry across the
columns.
Therefore it is important that I only count the number of individuals
(i.e.
Rows) and NOT the number of occurrences of 'Harm Reduction'.

I have been trying to use SUMPRODUCT but that only seems to count
occurences.

Has anyone got any ideas, please??!!

Thanking anyone in advance,

Roy