copying a sum formula across worksheets

joneric

New Member
Joined
Apr 18, 2002
Messages
1
I am creating worksheets that have MTD columns and YTD columns.
I am using the formula =SUM('march'!b1+a1) where b1 is the YTD total from the march worksheet and a1 is the MTD total from the april worksheet.
When I copy the worksheet to create one for a new month, I want the new worksheets formula to automatically be =SUM('march'!b1+'april'!b1+a1)
But what I am getting is that the formula remains =SUM('march'!b1+a1)
How do I do this???
This message was edited by joneric on 2002-04-19 22:19
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Create two sheets, say YearStart and YearEnd.
these should be copies of your Month Sheets and either side of your month sheets i.e. YearStart,January,February,March,YearEnd.

on your YearSummary Sheet in the correct cell put =SUM( Click on the first Sheet And hold Shift And select the Last Sheet a Click in the Cell you need to sum.

press ',' then click in the cell on the summary that you need.

you should end up with something like this:

=SUM(YearStart:YearEnd!B1,YearSummary!A1)

now every time you need to add a sheet make sure it's after the last month and BEFORE the YearEnd sheet and it will be included in the SUM().

You can also hide these sheets and it will still work for the formula.

_________________
Share the wealth!!
Ian Mac
This message was edited by Ian Mac on 2002-04-20 01:29
This message was edited by Ian Mac on 2002-04-20 01:30
 
Upvote 0

Forum statistics

Threads
1,213,568
Messages
6,114,348
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top