Is it possible to sum a certain cell in all sheets in Google Sheets?

[jwillits]

For instance, trying to sum C2 across all google sheets in a single file. Is this possible?

A new sheet gets added every day, with the name of the date for that day, and I am trying to get around changing the formula every day I add a new sheet, but I need to sum either a cell in all sheets, or in a range of sheets, like between Sheet1 and Sheet14 without listing every individual sheet.

 

[My Aswer Is This]

For instance, trying to sum C2 across all google sheets in a single file. Is this possible?

A new sheet gets added every day, with the name of the date for that day, and I am trying to get around changing the formula every day I add a new sheet, but I need to sum either a cell in all sheets, or in a range of sheets, like between Sheet1 and Sheet14 without listing every individual sheet.

Try something like this: This example would be for a sheet named Sheet1 to a sheet named Last

=SUM(Sheet1:Last!C2)​

 

[My Aswer Is This]

Not sure how to refer to last sheet in workbook when name constantly changes due to todays date. Also I do use Google sheets so not sure if this may work with Google sheets.

 

[jwillits]

While this works in excel, I do not think it works in google sheets or at least I do not know how to make it work in google sheets