Thanks for interest in my post,
Sorry for weak English,
Sir, I think you also did not understand, what my problem.
I have already placed sumif Formula in Monthly sheet for Monthly Report. Now i want a formula that auto update that sumif formula in monthly sheet,
as i have used sum if formula in column F to L.
As now i have created 4 sheets before monthly sheet, And in Monthly sheet formula is =SUMIF('02 DEC'!$B:$B,MONTHLY!$B6,'02 DEC'!F:F)+SUMIF('03 DEC'!$B:$B,MONTHLY!$B6,'03 DEC'!F:F)+SUMIF('04 DEC'!$B:$B,MONTHLY!$B6,'04 DEC'!F:F)+SUMIF('05 DEC'!$B:$B,MONTHLY!$B6,'05 DEC'!F:F)
I want auto update above formula If I enter new sheet like ''06 DEC''. Then formula should auto update by the name of sheet "06 Dec" in Monthly sheet cells E5 to L403.
AS adding new sheet "06 DEC"
=SUMIF('02 DEC'!$B:$B,MONTHLY!$B6,'02 DEC'!F:F)+SUMIF('03 DEC'!$B:$B,MONTHLY!$B6,'03 DEC'!F:F)+SUMIF('04 DEC'!$B:$B,MONTHLY!$B6,'04 DEC'!F:F)+SUMIF('05 DEC'!$B:$B,MONTHLY!$B6,'05 DEC'!F:F)+SUMIF('06 DEC'!$B:$B,MONTHLY!$B6,'06 DEC'!F:F)
Is this is possible?
I think this is possible......
Or any relevant formula, which sum all previous sheet's specific value of cells..
Thanks,,,
And Ignore if you don't understand,,![]()
Bookmarks