# Excel sum from multiple columns where date between several columns

#### and2009

##### New Member
I need help with excel sum calculating!
I have a table with 4 Amount Fields and 4 Date Fields

I need to Calculate sum from all amount columns which are in particular month and get a result like this:
January 2016 - Total Sum
January 2017 - Total Sum

etc...
[FONT=Arial, Helvetica Neue, Helvetica, sans-serif]
[/FONT]
[FONT=Arial, Helvetica Neue, Helvetica, sans-serif]I already try this: =SUMIFS(A2:A9,B2:B9,">="&"09/01/2016",B2:B9,"<="&"09/30/2016") [/FONT]for finding the sum for column A between dates in column B, but i cant figure out how to accomplish calculating sum for all Amount Columns which are between all Date Columns...

Thank You in advance for your help...

****** id="cke_pastebin" style="position: absolute; top: 40px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
 I need help with excel sum calculating! I have a table with 4 Amount Fields and 4 Date Fields Excel Table I need to Calculate sum from all amount columns which are in particular month and get a result like this: January 2016 - Total Sum January 2017 - Total Sum etc... I already try this: =SUMIFS(A2:A9,B2:B9,">="&"09/01/2016",B2:B9,"<="&"09/30/2016") for finding the sum for column A between dates in column B, but i cant figure out how to accomplish calculating sum for all Amount Columns which are between all Date Columns... Thank You in advance for your help...

<tbody style="margin: 0px; padding: 0px; border: 0px;">
</tbody>
</body>

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

#### Scott T

##### Well-known Member
Just add multiple SUMIFS formulas
Code:
``=SUMIFS(A2:A9,B2:B9,">=09/01/16",B2:B9,"<=9/30/16")+SUMIFS(C2:C9,D2:D9,">=09/01/16",D2:D9,"<=9/30/16")+SUMIFS(E2:E9,F2:F9,">=09/01/16",F2:F9,"<=9/30/16")+SUMIFS(G2:G9,H2:H9,">=09/01/16",H2:H9,"<=9/30/16")``

Replies
6
Views
109
Replies
31
Views
446
Replies
3
Views
141
Replies
15
Views
218
Replies
11
Views
432

1,136,317
Messages
5,675,042
Members
419,546
Latest member
RobWayCot

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

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