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