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
|