Sum Function
Let's say that in each sheet the monthly value is in B9 and we want the cumm
to date in B10.
In Feb sheet in cell B10 enter:
=B9+Jan!B10
In the Mar sheet in B10 enter:
=B9+Feb!B10
etc.
B10 builds cummulatively month-by-month
--
Gary''s Student - gsnu200772
"Roger" wrote:
I have 12 different worksheets for each month in a year in one workbook. In
each month's worksheet, I want year-to-date figures up to that month. All
the worksheets have the same fields in same cells. I prepare one worksheet
with all data and formulas for one month. Then I name the worksheet "Jan"
for January and copy that worksheet 11 times and rename them according to
individual months.
How can I insert a common formula that will work in every worksheet for
getting the year-to-date figures in each month's worksheet?
Thanks in advance for your time.
|