For Bob:
=SUMPRODUCT(--(A2:A100="X"),--(B2:B100="Bob"))

For John
=SUMPRODUCT(--(A2:A100="X"),--(B2:B100="John"))

HTH,
Paul

--

"bhammer" wrote in message
...
Excel 2003,

Simple, I hope. Column A has "X"s here and there (like checkmarks).
Some are blank. Column B has either "Bob" or "John". I want a cell to
total the number of X's for Bob, and another cell to total the X's for
John.
-Brad