Formula

  • Thread starter Thread starter rylv5050
  • Start date Start date
R

rylv5050

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!
 
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
 
Back
Top