I am trying to figure out how to get a running total that automatically deducts a value once it has been "x" out.
Basically, I keep a spreadsheet of all my fixed recurring Annual Bills i.e. (School, Real Estate Taxes, Insurances and stuff like that) and I have the total cost of all these expenses at the bottom.
When I pay an expense off I put an "x" in a yearly column.
What I want to do is have the Total automatically deduct from the Yearly total everytime I put in a new "x".
I know this is a Math problem but my High School education is failing me. LOL. Please Help!
Here is an example of what I need:
Annual Expenses AMOUNT DUE 2009 2010 2011 2012
Neighborhood Association Fee $300.00 1-Jan x x x x
School Tuition $10,000.00 15-Jan x x x x
Irrigation Company $300.00 1-Mar x x x x
Lawn Care $400.00 15-Mar x x x x
Stickers for Car $100.00 31-Mar x x x x
Car Insurance (First Half) $850.00 3-Apr x x x
Safety Deposit Box $100.00 1-Jul x x x
Real Estate Taxes $7,000.00 1-Jul x x x
Health Insurance $4,000.00 13-Jul x x x
Life Insurance $250.00 31-Jul x x x
Stickers for Car $100.00 31-Aug x x x
Home Owners Insurance $1,200.00 4-Sep x x x
Disabilty Insurance $1,300.00 25-Sep x x x
Car Insurance (Second Half) $850.00 3-Oct x x x
Total $26750.00 $15650 <--- This is what I want to have. A running total minus all the "x" totals.
Bookmarks