I have a file with 31 sheets, one for each day and 1 sheet for the monthly totals.
I have a sheet for everyday of the month, sheets are named 1 ,2, 3 ,........
I have a sheet for the total month, I want to sum all of the 31 sheets(days) on the month sheet.
For example on the month sheet, I want to sum in cel C8 all of the 31 sheets(days) cel c8 such as ="1"c8+"2"c8+"3"c8...............
Is there an easier formula than this one?
Bookmarks