Yea, that would work too. Didnt consider at the time.

isnt there a way to check the entire column without specifing 65k. I know
there is but cant think of it.
--

Fighting Texas Aggie Class of 2009


"Max" wrote:

.. I'm trying to count the number of John Doe's, Jane Dane's & Jack Dark's
in column B if column G has value of 'yes' or 'no'.

Another option, normal ENTER will do:
=SUMPRODUCT((ISNUMBER(MATCH(B6:B100,{"John Doe";"Jane Dane";"Jack
Dark"},0)))*(ISNUMBER(MATCH(G6:G100,{"Yes";"No"},0 ))))

Adapt the ranges to suit. For good recalc performance, use the smallest
range large enough to cover the max expected extent of your data (do you
really need to go down to row 65k?)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---