r/googlesheets•
hamdogus

SUM of the same cell across multiple sheets?

Unsolved

Hello, I have a Daily Sales Report workbook with 1 sheet for each day; 1.7.2024, 2.7.2024, etc.

I would like to sum all the values of e.g. cell I4 for a whole month of sheets; 1.7.2024 - 31.7.2024

I was able to use a custom function to return the list of sheet names and then reference one cell using

=indirect(H$3&"!"&"I4")

Where H3 is the first sheet name in the list and I4 is the cell value I want to use.

So I would like a formula to add all the values in I4 from H3:H33.

Thank you for any help!

Posted Aug 8, 2024, 9:04 AM UTC

25
Loading comments…