Hi Bernard Liengme,

Really thanks a lot for the help... Appreciate a lot for the help..

Regards,

Bernard Liengme wrote:
None of the above but use SUMPRODUCT
=SUMPRODUCT((A2:A11=1001)*(MONTH(B1:F1)=12)*B2:F1 1)
best wishes
Hi,

[quoted text clipped - 38 lines]
11 1005 1 1 1 2
1