Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Count Condition
Hello all,
I'm trying to create a multiple condition count and I can't get it to work using all the examples I've found. I'm hope someone can help me out. Here's the formula I've trying to manipulate (unsuccessfully): =COUNT(('Grindex 2008'!AB:AB="Jan-2")*('Grindex 2008'!AB:AB="Jan-3")*('Grindex 2008'!Y:Y="Jan-D")) So if (column AB = "Jan-2" OR column AB = "Jan-3") AND column Y = "Jan-D" then count the row. I'm drawing a complete blank. Anyone know the correct format? I can't see to find a good example on how to structure the formula. Thanks, Jay -- Disregard, this is so I can find my post later. ***postedbyJay*** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
helps with count under multiple condition | Excel Discussion (Misc queries) | |||
Count multiple condition | Excel Programming | |||
What formula/fn would I use to count multiple condition records? | Excel Worksheet Functions | |||
how to count unique entries with multiple condition | Excel Worksheet Functions |