|
Amount Spent vs Budget
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 |
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 |
Amount Spent vs Budget
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. |
Amount Spent vs Budget
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 "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 |
| All times are GMT +1. The time now is 06:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com