Macth Index Sumif linked to a dynamic cell

[Sifre1013]

I a fan or you’re your and first I like to thank you so much for teaching us.<o></o>
<o> </o>
I like to bring the value of an Expense Account that it is in another worksheet (Income Statement) which has all accounts and its value per months. All values changes every month. Worksheet 1, will be prepared each month and contain information per month in a different format than the other Income statement. <o></o>
I want to look for the specific account or accounts, sum those values only if they match to the month of the Worksheet 1, let say 13-Mar and DROP List (Jan 13,Feb-13,Mar-13,Apr -13,May -13, etc…) is on Worksheet 1, on let say G1. The list shows the Months are they are shown on the Income Statement.<o></o>
<o> </o>
I would also like that if I change the month in the Drop list in worksheet 1, it will update the numbers in this worksheet.<o></o>
<o> </o>
What do you recommend me to do?<o></o>
<o> </o>
Thanks in advance<o></o>
<o> </o>
Worksheet 1<o></o>

	ACTUAL</SPAN></SPAN>	BUDGET</SPAN></SPAN>	VARIANCE</SPAN></SPAN>
	13-Mar</SPAN>	3/13</SPAN></SPAN>
Expense 1</SPAN></SPAN>	50</SPAN>
Expense 3 & 4	10</SPAN></SPAN>

<TBODY>
</TBODY>

Worksheet 2 (Income Statement)</SPAN></SPAN>

G/L #</SPAN></SPAN>

DESCRIPTION</SPAN></SPAN>

Jan-13</SPAN></SPAN>

Feb-13</SPAN></SPAN>

Mar-13</SPAN></SPAN>

Etc…</SPAN></SPAN>

<TBODY>
</TBODY>

2075 Expense 1 120 30 50</SPAN></SPAN></SPAN>
2076 Expense 2 70 9 10</SPAN></SPAN>
2970 Expense 3 10 2 7</SPAN></SPAN>
2971 Expense 4 11 3 3</SPAN></SPAN>

Thanks!!!

 

[jamtay317]

is all of the data on the same page?

 

[Sifre1013]

is all of the data on the same page?

Sorry I had a problem with my password....

Yes, for the Actual the data is on Worksheet 2.<o></o>
My Drop List (13-Mar) is on Worksheet 1, G11.<o></o>
Data for the column of Actual is on Worksheet 2 (Income Statement) and is goes from A2 to P2 for the titles as follows:<o></o>
<o> </o>
<o> </o>

G/L #<o></o>​

DESCRIPTION<o></o>​

CODE<o></o>​

Jan 13<o></o>​

Feb-13<o></o>​

Mar-13<o></o>​

Apr -13<o></o>​

May -13<o></o>​

Jun -13<o></o>​

Jul -13<o></o>​

Aug-13<o></o>​

Sep -13<o></o>​

Oct-13<o></o>​

Nov 13<o></o>​

Dec-13<o></o>​

YTD<o></o>​

<TBODY> </TBODY>

<o> </o>
The whole Worksheet 2, goes from A2 to p143, the values start from D3 to P134<o></o>




Worksheet 1

		MONTHLY
		ACTUAL	BUDGET	VARIANCE
		13-Mar	3/13
ATM fees		#N/A	18800.00	6944.78
ATM GENERATED FEES	#N/A	1200.00	-265.92
Checkbook charges		2103.35	1600.00	503.35
Controlled disb (comm accts)	3170.26	3300.00	-129.74
Currency exch-CAD		81580.81	100000.00	-18419.19

<COLGROUP><COL style="WIDTH: 130pt; mso-width-source: userset; mso-width-alt: 4920" width=173><COL style="WIDTH: 18pt; mso-width-source: userset; mso-width-alt: 682" width=24><COL style="WIDTH: 60pt" span=2 width=80><COL style="WIDTH: 79pt; mso-width-source: userset; mso-width-alt: 2986" width=105><TBODY>
</TBODY>

Worksheet 2

G/L #	DESCRIPTION	CODE	Jan 13	Feb-13	Mar-13	Apr -13	May -13	Jun -13	Jul -13	Aug-13	Sep -13	Oct-13	Nov 13	Dec-13	YTD
44600	ATM expense	Other expense	13,082.68	17,772.61	10,387.25	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	41,242.54
44625	ATM Debit card expenses	Other expense	3,280.42	2,850.49	3,118.40	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	9,249.31
44635	Overdraft expenses	Other expense	469.38	777.18	225.60	956.69	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	1,472.16

<COLGROUP><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2332" width=82><COL style="WIDTH: 197pt; mso-width-source: userset; mso-width-alt: 7480" width=263><COL style="WIDTH: 178pt; mso-width-source: userset; mso-width-alt: 6741" width=237><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3128" span=2 width=110><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3128" width=110><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3128" span=9 width=110><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 3128" width=110><TBODY>
</TBODY>