# Sumif, match and index based on Month End and thee # of the acct

#### Sifre1013

##### New Member
Hello,<o></o>
I like to bring the values of Accounts that are in otherworksheet based on two conditions, the number of the account and the month ofthe year.<o></o>
I would also want to use a Drop List for the months,such as (Jan 13,Feb-13,Mar-13,Apr -13,May -13, etc…) in Worksheet 1, so, I canchoose another date and the balance would update automatically. <o></o>
All values are on the Worksheet 2. Drop List <o></o>
 ACTUAL
<tbody> </tbody>
Mar-13
ATM fees #N/A
ATM GENERATED FEES
Checkbook charges
What is wrong with this formula =SUMIF(\$A\$13:\$A\$15,44600,INDEX(,MATCH(D1,\$D\$12:\$P\$15,0),\$D\$13:\$P\$15))
Worksheet 2
 G/L #
<tbody> </tbody>
DESCRIPTIONJan 13Feb-13Mar-13Apr -13May -13Jun -13Jul -13Aug-13Sep -13Oct-13Nov 13Dec-13YTD
44600ATM expense 13,082.68 17,772.61 10,387.25 - - - - - - - - - ######
44625ATM Debit card expenses 3,280.42 2,850.49 3,118.40 - - - - - - - - - ######
44635Overdraft expenses 469.38 777.18 225.60 956.69 - - - - - - - - ######
Thanks
<tbody> </tbody>
<!--[endif]--><!--[if !mso & vml]><![endif]-->
<colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="179" style="width: 134pt; mso-width-source: userset; mso-width-alt: 6546;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;" span="3"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;" span="2"> <col width="52" style="width: 39pt; mso-width-source: userset; mso-width-alt: 1901;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;" span="2"> <col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;"> <col width="49" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1792;"> <col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"> <col width="56" style="width: 42pt; mso-width-source: userset; mso-width-alt: 2048;"> <tbody> </tbody>
<!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" oreferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"/> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"/> <v:f eqn="sum @0 1 0"/> <v:f eqn="sum 0 0 @1"/> <v:f eqn="prod @2 1 2"/> <v:f eqn="prod @3 21600 pixelWidth"/> <v:f eqn="prod @3 21600 pixelHeight"/> <v:f eqn="sum @0 0 1"/> <v:f eqn="prod @6 1 2"/> <v:f eqn="prod @7 21600 pixelWidth"/> <v:f eqn="sum @8 21600 0"/> <v:f eqn="prod @7 21600 pixelHeight"/> <v:f eqn="sum @10 21600 0"/> </v:formulas> <vath o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/> <o:lock v:ext="edit" aspectratio="t"/></v:shapetype><v:shape id="Picture_x0020_3" o:spid="_x0000_i1025" type="#_x0000_t75" style='width:468pt;height:263.25pt;visibility:visible;mso-wrap-style:square'> <v:imagedata src="file:///C:\Users\More\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png" o:title=""/></v:shape><![endif]--><!--[if !vml]--><!--[endif]--><o></o>
<o> </o>
<o> </o>
<o> </o>
<o> </o>
<o> </o>

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Replies
1
Views
2K
Replies
1
Views
494
Replies
7
Views
992
Replies
0
Views
843
Replies
3
Views
767

1,216,095
Messages
6,128,795
Members
449,468
Latest member
AGreen17

### 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.

### Which adblocker are you using?

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

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