Allow a circular reference

[Nali]

I need a formula that keeps a running total.

I have a Year-To-Date colume that I want to accumulate in for each new month.
I want this colume to add the current number with the number from my monthly colume.
I am creating a circular reference by using the figure in the YTD cell that I want to allow.

Help please...

 

[Paul]

I need a formula that keeps a running total.

I have a Year-To-Date colume that I want to accumulate in for each new month.
I want this colume to add the current number with the number from my monthly colume.
I am creating a circular reference by using the figure in the YTD cell that I want to allow.

If I understand you correctly, you should be adding this month's number to
the previous year-to-date figure, which will be in the row above. For
example, let's say column A is monthly number and column B is YTD, with
October's figures in row 10 and November's in row 11. Then the formula for
Nov YTD (cell B11) should be
=B10+A11 which will not create a circular reference.

If, however, you mean that you only have one month's figures present at a
time, but you want a cell to display a YTD number that includes figures that
were there previously, you shouldn't do this. Whilst it is just about
possible to set it up, there's no 'audit trail' and it's prone to errors
that will be impossible to see.

 

[J.E. McGimpsey]

take a look at

http://www.mcgimpsey.com/excel/accumulator.html