=IF(TODAY()<=DATE(2009,6,30),0,SUMPRODUCT(--('R3 2009 EC''s'!$C$3:$C$854="CAT3,"CAT4"),--('R3 2009 EC''s'!$AL$3:$AL$854<>"EC Approved")))
I am using the above formula to count overdue categories after 30 June '09. whe I have CAT1 and CAT2 as single items the formula works ok. But when I try to combine CAT3 & CAT4 I get an error.
Any pointers would be appreciated.
thanks
Salar
I am using the above formula to count overdue categories after 30 June '09. whe I have CAT1 and CAT2 as single items the formula works ok. But when I try to combine CAT3 & CAT4 I get an error.
Any pointers would be appreciated.
thanks
Salar