Running minus Total of 2 columns.

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.

could you attach a excel workbook copy of this

Hi

Try this arrey function (press Ctrl + shift +enter)

Please Login or Register  to view this content.

Hi
Thanks & welcome

Please mark the thread as solved

See my signature

Regards