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
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
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)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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
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?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.
Thanks for looking at it...
Not sure what you were saying there, so are you happy with the solution now?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Yes thank you...