hi,
'=SUMPRODUCT(($F$15:$F$23=$B6)*($F$15:$F$23=$B6)*($E$15:$E$23<=4),--(MONTH($D$15:$D$23)=VALUE(TEXT(K$5&"-2001","M"))),($E$15:$E$23))
This is the nearest working formula but the only PROBLEM is the result in "SUM" instead of "COUNT"
can someone help. ?? plzz
Regards,
LN