Excel sum from multiple columns where date between several columns

1
votes

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

1
exceldatesumifs
What you're requesting isn't clear. Perhaps post another image with faked results in the format you desire. – Tony

1 Answers

2
votes

Try this:

=SUMIFS(A2:G9,B2:H9,">="&"09/01/2016",B2:H9,"<="&"09/30/2016")

Note how the columns are offset by one.

enter image description here