YTD calculation

[Michael]

I run spreadsheets with monthly columns for actual,
budget, and variance. I have final YTD columns. I
currently go in and add the latest month to get this
total. It would be simpler if I could have a YTD cell with
a value like 3 for March. If I then had text in column 1
it would sum 2,5 and 8 for actual, 3,6 and 9 for budget
and 4,7 and 10 for variance. Changing just the YTD cell
value to 4 for April would change this calculation. Anyone
have a suggestion? Thanks. Michael

 

[Peo Sjoblom]

=MONTH(TODAY())

will return 11 for November or 4 for April

 

[rbanks]

Try something like this. In the attached file, is the data sheet tha
you can link all of your reports to.

Make all reports allways reference the "Current Month" (Column Q) an
"YTD" (Column R).

change the value in cell A1 to change the month.

ric

+----------------------------------------------------------------
| Attachment filename: ytd_sample.xls
|Download attachment: http://www.excelforum.com/attachment.php?postid=364378
+----------------------------------------------------------------

 

[Don Guillett]

Post your existing formulas