Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count cells with multiple criteria and two rows
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:E 30,"CO007") + count(if(worksehet2!B2:B30,"*d") etc. but that didn't work. Please help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
count cells using multiple criteria | Excel Worksheet Functions | |||
Count nonblank cells with multiple criteria | Excel Worksheet Functions | |||
count cells using multiple criteria | Excel Discussion (Misc queries) | |||
Count rows based on multiple criteria | Excel Worksheet Functions |