Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |