"bmstar" wrote:
Thanks Max. I appreciate your time and offering of your ability!

You're welcome. I'll presume it worked for you?

One more Question.....
Can I use wildcards in the search function or search for an {array} of
criteria?

SEARCH in itself is implicitly wildcard <g.

The suggested =SUMPRODUCT((ISNUMBER(SEARCH("P",'Game Play
Sheet'!J11:J100)))*( ... )) illustrates one possible usage of SEARCH in
SUMPRODUCT

=SUMPRODUCT(--ISNUMBER(SEARCH({"P","Q"},B2:B5)))
would be another "wildcard" example, this time with an array search,
ie search for either "P" or "Q" within B2:B5
(w/o case sensitivity)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---