Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rylv5050 rylv5050 is offline
external usenet poster
 
Posts: 11
Default 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!