=COUNTIF(B1:B100,"xxx")
assuming B1:B100 is the right column.
--
HTH
Bob Phillips
"Egon" wrote in message
oups.com...
I'm having a mess of a time getting this to work.
I have an array from a report. I need to count the people in the left
column who have a certain value in the right column. I'm doing
something wrong, or its monday morning and I can't seem to get it to
work.
Can anyone help me out here?
J.
|