Formula
 

I am counting in one sheet, the rows of data that fit my criteria in another
worksheet across multiple columns. See below:
=SUMPRODUCT(--('Battle Mountain'!A27:A325="AT&T"),--('Battle
Mountain'!G27:G325="BLACKBERRY"))

Here I am counting all AT&T BLACKBERRY in the sheet Battle Mountain but I
need to add one more piece of criteria - AND BLACKBERRY BOLD's. Can I set a
wild identifier to count everything BLACKBER* or how do I add the next and
statement to my formula above.

Thank you very much!

Formula
 

Try this:

=SUMPRODUCT(--('Battle Mountain'!A27:A325="AT&T"),--(ISNUMBER(SEARCH
("BLACKBER",'Battle Mountain'!G27:G325))))

I think this is what you mean, which is really Blackberry OR
Blackberry Bold (or any other Blackber*), not AND - it can't be both
at the same time !!

Hope this helps.

Pete

On Aug 21, 1:11*am, rylv5050
wrote:
I am counting in one sheet, the rows of data that fit my criteria in another
worksheet across multiple columns. * See below:
=SUMPRODUCT(--('Battle Mountain'!A27:A325="AT&T"),--('Battle
Mountain'!G27:G325="BLACKBERRY"))

Here I am counting all AT&T BLACKBERRY in the sheet Battle Mountain but I
need to add one more piece of criteria - *AND BLACKBERRY BOLD's. *Can I set a
wild identifier to count everything BLACKBER* or how do I add the next and
statement to my formula above.

Thank you very much!