CODEWITHSUNDEEP
exceldatesumifs
user3782230
user3782230

Reputation: 155

Excel sum from multiple columns where date between several columns

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

Upvotes: 1

Views: 1597

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

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

Upvotes: 2

Related Questions