Multiple Count Condition
I also tried this but it doesn't produce the expected value.
=COUNT(IF(('Grindex 2008'!AB:AB="Jan-2")*('Grindex
2008'!AB:AB="Jan-3"),IF('Grindex 2008'!Y:Y="Jan-D",'Grindex 2008'!Y:Y)))
--
Disregard, this is so I can find my post later.
***postedbyJay***
"Jay" wrote:
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***
|