Sum the same cell across the sheets in Google Sheets

Question

I have a sheet for every day in the month. At the end of every month, I need to sum the same cell across all tabs. The following works:

=SUM(March31!L2,March30!L2,March29!L2,March28!L2,March26!L2,March25!L2,March24!L2)

However, at the end of the month, the formula will be tremendous. Tried the following:

=SUM(March31:March1!L2)

Doesn't work. Is it even possible?

On a more important note,a sheet for every month/day is a bad bad idea (commonly rookie error). It's preferable to enter all data ina single sheet — TheMaster, Apr 03 '20 at 16:45
Because It's not maintainable and you'll run into problems like this — TheMaster, Oct 16 '21 at 19:17

score 1 · Accepted Answer · edited Oct 06 '22 at 21:27

1

SUM(March31:March1!L2)

That won't work, but you can use kind of a generator:

={" "; ARRAYFORMULA("=SUM("&TEXTJOIN(", ", 1, TEXT(ROW(INDIRECT(
 DATEVALUE("2020/01/01")&":"&DATEVALUE("2020/12/31"))), "mmmmd!L2"))&")")}

which will give you the full formula you need so all you need to do is copy-paste the cell below:

Spreadsheet demo

edited Oct 06 '22 at 21:27

halfer

answered Apr 02 '20 at 22:00

player0

1

Thank you! That works! Yes, I am a rookie in the spreadsheet. Please clarify why using a sheet for every month/day is a "bad bad idea"? As for me, it looks well-structured – Alex Apr 03 '20 at 19:21