Fill Budget Sheet From Expense Totals Sheet

[Legacy 396030]

Hello all,

I have been trying to auto fill the actual expense amounts on each month's budget sheet without success. I would greatly appreciate any help with the formulas to amend each sheet based on the category and month for the actual amounts from the Expense Totals worksheet.
Where the word 'Template' appears will be the month of the year. Maybe this can be for matching to the Expense Totals sheet?
Thank you very much in advance for your help.

Expense Totals

	A	B	C	D	E	F	G
2	Category List	Jan-2017	Feb-2017	Mar-2017	Apr-2017	May-2017	Jun-2017
3	***Home Expenses***	January	February	March	April	May	June
4	Mortgage/Rent	$1,300.00	$1,389.00	$1,395.00	$0.00	$0.00	$0.00
5	Home/Rental Insurance	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
6	Electricity	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
7	Gas/Oil	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
8	Water/Sewer/Trash	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
9	Phone	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
10	Cable/Satellite	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

<tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B4 =SUMPRODUCT(--('Expense Log'!$D$3:$D$501=$A4),--(MONTH('Expense Log'!$A$3:$A$501)=MONTH(B$2)),'Expense Log'!$B$3:$B$501) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4


Template

	A	B	C
1	Back to Switchboard	Template	2017
2
3	BUDGET SUMMARY	Budget	Actual
4	Total Income	$0.00	$0.00
5	Total Expenses	$0.00	$0.00
6	NET	$0.00	$0.00
7
8	INCOME	Budget	Actual
9	Wages & Tips		$0.00
10	Interest Income
11	Dividends
12	Gifts Received
13	Refunds/Reimbursements
14	Transfer from Savings
15	Other
16	Other
17	Total INCOME	$0.00	$0.00
18
19	HOME EXPENSES	Budget	Actual
20	Mortgage/Rent
21	Home/Rental Insurance
22	Electricity
23	Gas/Oil
24	Water/Sewer/Trash

<tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B1 =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4