take a look at COUNTIF function in help

"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.