# Running minus Total of 2 columns.

1. ## 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.

2. ## Re: Running minus Total of 2 columns.

Sorry I really should have previewed my post first. It all lined up fine in the post window. If you can just imagine all the columns are aligned up and the \$15650 is below the last column of "x" then this is accurate. Please feel free to ask me any questions. Thanks again.

3. ## Re: Running minus Total of 2 columns.

could you attach a excel workbook copy of this

4. ## Re: Running minus Total of 2 columns.

Sample Excel for Forums.xlsx

This is an example Excel sheet I created. Hope it uploads properly.

5. ## Re: Running minus Total of 2 columns.

Hi

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

``Please Login or Register  to view this content.``

6. ## Re: Running minus Total of 2 columns.

Hi
Thanks & welcome

See my signature

Regards

7. ## Re: Running minus Total of 2 columns.

Got it thanks. New to the forum. That SOLVED is really buried. LOL. Thanks again for the excellent support and help.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1