Macth Index Sumif linked to a dynamic cell

Sifre1013

New Member
Joined
Apr 17, 2013
Messages
3
I a fan or you’re your and first I like to thank you so much for teaching us.<o:p></o:p>
<o:p> </o:p>
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:p></o:p>
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:p></o:p>
<o:p> </o:p>
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:p></o:p>
<o:p> </o:p>
What do you recommend me to do?<o:p></o:p>
<o:p> </o:p>
Thanks in advance<o:p></o:p>
<o:p> </o:p>
Worksheet 1<o:p></o:p>



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!!!
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Sifre1013

New Member
Joined
Apr 17, 2013
Messages
3
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:p></o:p>

My Drop List (13-Mar) is on Worksheet 1, G11.<o:p></o:p>
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:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
G/L #<o:p></o:p>
DESCRIPTION<o:p></o:p>
CODE<o:p></o:p>
Jan 13<o:p></o:p>
Feb-13<o:p></o:p>
Mar-13<o:p></o:p>
Apr -13<o:p></o:p>
May -13<o:p></o:p>
Jun -13<o:p></o:p>
Jul -13<o:p></o:p>
Aug-13<o:p></o:p>
Sep -13<o:p></o:p>
Oct-13<o:p></o:p>
Nov 13<o:p></o:p>
Dec-13<o:p></o:p>
YTD<o:p></o:p>

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




Worksheet 1

MONTHLY
ACTUALBUDGETVARIANCE
13-Mar3/13
ATM fees #N/A18800.006944.78
ATM GENERATED FEES#N/A1200.00-265.92
Checkbook charges 2103.351600.00503.35
Controlled disb (comm accts)3170.263300.00-129.74
Currency exch-CAD 81580.81100000.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 #DESCRIPTIONCODEJan 13Feb-13Mar-13Apr -13May -13Jun -13Jul -13Aug-13Sep -13Oct-13Nov 13Dec-13YTD
44600ATM expenseOther expense13,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
44625ATM Debit card expensesOther expense3,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
44635Overdraft expensesOther expense469.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>
 

Watch MrExcel Video

Forum statistics

Threads
1,123,043
Messages
5,599,479
Members
414,312
Latest member
mikefire911

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top