Formular required for month and YTD

[Guest]

H

I am trying to figure out how to create a formular to keep the weekly figures rolling into month and YTD. The idea is to be able to go into the spreadsheet each week and overtype the figures in column A and also have the new figure add on to colum B & C. Any idea's

A B
1 Week Month YT
2 10 100 20

Regard
Trac

 

[Andy Brown]

Any idea's?

??? ; you can't just put amounts under "Week" ; you'll need some dates in
there somewhere, or "Month" and "YTD" won't know where they are.

Consider using a pivot table
(http://peltiertech.com/Excel/Pivots/pivottables.htm) grouped by months and
years, with a dynamic named range
(http://www.contextures.com/xlNames01.html#Dynamic) for the source data.

HTH,
Andy