get a count from multiple lookups

Thanks Max. I appreciate your time and offering of your ability!

One more Question.....

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

Thanks again!

Ben

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

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