| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
One way
=SUMPRODUCT(--((B2:B200="Blue")+(B2:B200="Red")0),--((C2:C200="Dave")+(C2:C200="Steve")0)) -- Regards, Peo Sjoblom (No private emails please) "PhilH" wrote in message ... Thanks, but what if you have a third column that contains names and you only want to count items that relate to either "Red" or "Blue" for column B and "Dave " or "Steve" for column C. "PhilH" wrote: I understand how to a mutiple condition sum using an array formula following the format that is created by the conditional simif wizard. Can count use multiple conditions in the same way, and if so how ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula, noncontigous range | Excel Worksheet Functions | |||
| Array formula help | Excel Discussion (Misc queries) | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
| Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
| What instead of an array formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
