=SUM(COUNTIF(A1:A200,{"John","Wanda"}))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
I have looked at other posting and haven't seem to have found a
similar one or haven't understood explanations.

Here goes.

Column A could have either a value of John or Wanda without 200 rows

Over in Column J there will be an "x" (on the same row of the name) if
column A has a value of John or Wanda.

Visual Aid:

Col A Col J
John x
Wanda x
John x
John x
Wanda x

Totals would be John 3 Wanda 2


Objective is to get a total of John's "x" 's AND a total of Wanda's
"x" 's.

Totals will then be captured on another worksheet using a formuala
pointing to their respective totals.

Sounds so easy, but not yet there.

Please help!
Thanks in advance.
Jay