Sum on the basis of mutiple criteria

[Veeru]

Hi,

i am looking forsum of Jano the basisof mutiple creteria and nmbers should update as and when we change month.

Details are given in sheet attached.

Thanks

[Bob Phillips]

This works for me


=SUMPRODUCT(($G$7:$G$18=$G22)*($H$7:$H$18=$H22)*(ISNUMBER(MATCH($I$7:$I$18, $I22:$I24,0)))*($K$7:$K$18=J$21)*$L$7:$L$18)

[Veeru]

Thanks but that will not solve my problem.

Right now my month is Jan in J21 but next month march dat will get updated then ...J21 will be feb and K21 will be Mar'18.

Please assist

[Bob Phillips]

Well, as I said it works for me on your workbook, even when I update the date in the base cells.

Why doesn't it work for you?

[Veeru]

Yes....but i guess we link J21 n K 21 to B6 n C6 and then go for if condition it will make work....so formula will looks like it is in sheet attached.

[Veeru]

Thanks for looking at it...

[Bob Phillips]

Not sure what you were saying there, so are you happy with the solution now?

[Veeru]

Yes thank you...