sum ifs with date range and multiple criteria

[CraKel]

I am new to Mr. Excel. I am trying to sum an set of expenses that occurred within a specific year and or date range. The challenge is to create a formula that includes multiple criterial. For example, I want to sum the following:
Total of all costs associated with marketing expenses for company A in the first quarter of 2014, from 1/1/14 to 3/31/14
Total of all costs associated with transportation expenses for company A in the first quarter of 2014, from 1/1/14 to 3/31/14
Total of all costs associated with Office expenses for company B in the first quarter of 2014, from 1/1/14 to 3/31/14
etc....

I was given a formula that is close to what I want, but does not include an end date to complete a range. Instead it is just a greater than value. The formula that is close that I used in cell i2 is:
=SUMIFS($D$15:$D$49950, $H$15:$H$49950, $G2, $B$15:$B$49950, $I$1,A15:A49950,">=" & DATE(2014,9,1))

See attached excel with the yellow highlighted field.

Thanks


I am not sure how to attach my sample excel to this forum so I made a screenshot which you can view HERE.

Thanks.

 

[FDibbins]

cross-posted (and answered) here...
sum ifs with date range and multiple criteria-V2

 

[CraKel]

I did not realize the website MrExcel.com was the same as ExcelForum.com, especially in light of the fact Mr. Excel did not allow users to post their spreadsheets. Thanks for clarifying. That said, how do I mark this as solved? I was able to mark solved on the Excel Form but can't seem to see the same option in the tools drop down menu on Mr. Excel. I want to make sure people know this is solved.

 

[Narendrareddy]

Try this Formula,

=SUMIFS($D$15:$D$49950,$H$15:$H$49950,$G2,$B$15:$B$49950,I$1,$A$15:$A$49950,">="&$B$2,$A$15:$A$49950,"<="&B3)

 

[CraKel]

Thank you. I just got this resolved.

 

[FDibbins]

I did not realize the website MrExcel.com was the same as ExcelForum.com,

They are not the same site, nor are they linked/related, however, members of 1 are often members of another.

 

[CraKel]

Got it. Thanks!

 

[Narendrareddy]

Your Welcome