SUM across multiple sheets

[JARichard74]

Workbook that has a Template sheet, Data sheet, Summary sheet and a sheet that gets added every day of the month. Each daily sheet is named e.g., 1-september, 2-september, etc. I want to add all J26 cells across all sheets where the formula adjusts to the last day i.e., on Sep 5 it would sum Sep 1 to 5, Sep 6 would sum Sep 1 to 6, etc. The total would be in the Summary sheet

Part 2 - In the same workbook, I would like to do a SUMIF. The items to sum are on each sheet in range N9:N18 and the sum range is on each sheet P9:P18 the criteria is that each item to sum in each sheet matches the list in the summary sheet (A11:A18). The total for each item would be in the Summary sheet (B11:B18)

 

[jasonb75]

This part of the formulas is what sets the date range to use.

SEQUENCE(DAY(MAX(TODAY(),EOMONTH($A$1,0))),,$A$1)

Changing it as below should allow for a 1 month range starting from the date in A1. It may be a bit of fine tuning to meet exact requirements but should make a good starting point.

SEQUENCE(MIN(TODAY(),EDATE($A$1,1))-$A$1,,$A$1)

Note that it will only work with current or past dates, if the current date is earlier than the date in A1 then it will show an error.

 

[JARichard74]

Merci for all your help.