count cells with multiple criteria and two rows

E

Erin

I have a spreadsheet with 4 different worksheets. I basically want to sum the
information from the 4 worksheets on a separate worksheet. From worksheet1, I
want to count the cells that contain the letter "D" from B2:B30, but only
count those that have a "D" if "CO007" is in E2:30......same criteria from
worksheet2, 3 and 4. I started with
=count(if(worksheet1!B2:B30,"*d")+(worksheet1!E2:E30,"CO007") +
count(if(worksehet2!B2:B30,"*d") etc. but that didn't work. Please help.
 
K

KC

=SUMPRODUCT(--(ISERROR(SEARCH("*D*",Sheet2!B2:B30))=FALSE),--(Sheet2!E2:E30="CO007"))

-kc
*Click YES if this helps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data between two tables 3
Reference to another worksheet cell in a sumproduct formula 1
Index match with multiple criteria(different than usual) 0
Index match with multiple criteria(different than usual) 3
SumIf with multiple Criteria 6
I need a Formula for a Database 3
matching multiple columns on different worksheets 1
Conditional Format with Name Range? 1

Top