View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Steve Jones Steve Jones is offline
external usenet poster
 
Posts: 32
Default Amount Spent vs Budget

Assuimg that your Budget Account 80311 is in cell A1 and assuming 80311
spent is in A1 in sheet "spent" you could select B1(in your budget account
sheet) and Enter =A1-spent!A1

This will return the budget amount less the spent amount.

Regards

Steve


"Sean DeBruler" wrote in message
...
Please help,
I Have a Log (Spreadsheet) where I track money being spent from several
accounts. (See Below)

Account # Amount
80311 $25.00
80928 $50.00
80937 $75.00
80311 $100.00

I also have a budget. (See Below) *Note* Same Account #'s
Account # Budgeted
80311 $1000.00
80928 $1000.00
80937 $1000.00

These are on seperate worksheets and I would like to subtract the money
I've
spent vs my budget. (See below)

Sheet 1 (Spent) Sheet 2(Budget)
Account # Amount Account # Budget Budget less
Amount (New)
80311 $25.00 80311 $1000.00 $975.00
80928 $50.00 80928 $1000.00 $950.00
80937 $75.00 80937 $1000.00 $925.00
80311 $100.00 I would like this amount to subtract from
the Budget Account #80311, bringing the "Budget less Amount" to $875.00

Is this possible
Thanks for the help
Sean