Is this possible?

[Microsoft Communities]

I have a workbook with anywhere between 29 and 31 worksheets.
Each worksheet is identical, representing sales information for each day of
the month.
I would like to create 1 sheet for the "Total Month To Date" for each cell
that contains any sales information.
I looked at a couple of merge examples but they just keep putting the
information next to each other. They do not add the information together.

 

[Pete_UK]

If your sheets have a name which is the day number for that month (eg
1, 2, 3 etc), then you can do this:

=SUM('1:29'!B2)

to add up all the B2 cells (for example).

If you put this in B2 of the summary sheet, then you can just copy to
other cells as required.

Hope this helps.

Pete

 

[AndyW]

I have a workbook with anywhere between 29 and 31 worksheets.
Each worksheet is identical, representing sales information for each day
of the month.
I would like to create 1 sheet for the "Total Month To Date" for each cell
that contains any sales information.
I looked at a couple of merge examples but they just keep putting the
information next to each other. They do not add the information together.

Yes
As an example I made a workbook with 4 sheets (names Sheet1 to Sheet4)
Assuming each sheet is the same format.
To add the totals of numbers in cell A1 in Sheets 1 to 3 the formula is
=SUM(Sheet1:Sheet3!A1)


Andy

 

[David Heaton]

Yes
As an example I made a workbook with 4 sheets (names Sheet1 to Sheet4)
Assuming each sheet is the same format.
To add the totals of numbers in cell A1 in Sheets 1 to 3 the formula is
=SUM(Sheet1:Sheet3!A1)

Andy

If you dont want to rename your sheets you can add two empty sheets.
place one at the start of your sheets and the other at the end.

=SUM(StartSheet:EndSheet!A1)


David