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!

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.

Quote:

---

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.

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.