Amount Spent vs Budget

[Guest]

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

 

[Steve Jones]

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

 

[MyVeryOwnSelf]

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

One way is to put this in Sheet2!C2 and copy down:
=$B2-SUMIF(Sheet1!A:A,$A2,Sheet1!B:B)

This assumes that each account appears once in Sheet2, possibly several
times in Sheet1, and you want the money being spent to be accumulated on
Sheet2.

 

[Steve Jones]

Assuming the Expenditure is in cell A1 for account 80311 in Sheet1 and
Budget is in cell A1 in sheet 2.

In cell B1 sheet2 Enter "=A1-Sheet1!A1" (without inverted commas).

That should return your budget amount less expenditure amount.

Regards

Steve