Is this possible?

  • Thread starter Thread starter Microsoft Communities
  • Start date Start date
M

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.
 
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
 
Microsoft Communities said:
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.
Click to expand...

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
 
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
Click to expand...

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
 
Back
Top