Excel sum from multiple columns where date between several columns

and2009

New Member
Joined
Mar 20, 2017
Messages
1
I need help with excel sum calculating!
I have a table with 4 Amount Fields and 4 Date Fields

MpE5u.jpg



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
Joined
Dec 14, 2016
Messages
2,623
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
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")
 

Forum statistics

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

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