Check out some similar questions!

jburchett · Sep 2, 2012, 04:23 PM

On my spreadsheet, I have one column (B) for monthly expenditures. The next column (C) is for the total yearly expenditure.

How can I create a formula that's not circular to do this:

Let's say my yearly expenditure is $1000 (Column C). This month I add $150 in column B. Column C should then be $1150.

Next month I add $100 to column B. Column C should be $1250.

How do I do this? Thanks!

pready · Sep 2, 2012, 04:33 PM

You can use the auto sum feature, which is the weird looking E in the upper right hand corner of the page on your home tab, or you can make one cell equal to one cell plus another cell or groups of cells.

jburchett · Sep 2, 2012, 04:49 PM

Originally Posted by pready

You can use the auto sum feature, which is the weird looking E in the upper right hand corner of the page on your home tab, or you can make one cell equal to one cell plus another cell or groups of cells.

Thanks, but that's not quite it. The E (AutoSum) Calculate each consecutive cell in the column (i.e. a running total). Adding the adjacent cell to this cell either gives the wrong number OR it's a circular formula.

Thanks, though.

ScottGem · Sep 2, 2012, 05:29 PM

If you want a running total in Col C then the formula would be:

=B3+C2

This adds the current amount to the previous total.

You then copy that formula down the column.