| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting occurrences of multiple conditions
How do I count the occurrences of more then 2 conditions? I have a formula
for 2 conditions "=sumproduct(($a$2:$a$500="list 1")*($b$2:$b$500=95))" that formula finds "list 1" in the range a2-a500, it then checks for "95" in the range b2-b500 and calculates the number of rows that contain both. I need to add one more into the mix. any thoughts? thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup with multiple conditions | Excel Worksheet Functions | |||
| counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) | |||
| SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
| Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
Threaded Mode
