sum ifs with date range and multiple criteria-V2

**Perk1961** · 03-29-2015, 07:23 PM

I attempted to find a solution in a previous post but came up short. I am attempting again via the Formulas & Functions Forum. I am trying to sum an set of expenses that occurred within a specific 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.

Any help in getting me across the goal line would be appreciated.Expense Templete V2.xlsx

**dos mios** · 03-29-2015, 07:35 PM

What is the expected answer? It looks like you want to sum up the numbers between the dates in B2:B3. If that's the case, would this help:

Formula:

Please Login or Register  to view this content.

Also, why did you create a new thread rather than keep the old one?

**Perk1961** · 03-29-2015, 07:56 PM

That did it! THanks so much.

I started a new thread because I stopped getting feedback on the old one. After a week+ I decided to post a new one, which you solved in less than an hour. Thanks again!

**FDibbins** · 03-29-2015, 08:03 PM

Perk, rather than post a duplicate thread - which the mods will close if we see it - if you have had no resplose to your thread aftre a day, post on it again, asking for help, or by re-phrasing your question.

If a thread sits in the list for a while, it will slowly get pushed down to page 2 or 3 etc, and will no longer be in the immediate view - in other words, it tends to slip through the cracks and gets lost.

You need to keep bumping it every day or so

**FDibbins** · 03-29-2015, 08:08 PM

hmmm also...
Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

http://www.mrexcel.com/forum/excel-q...-criteria.html

**Perk1961** · 03-29-2015, 09:27 PM

Thanks for clarifying. I am new to posting so appreciate the guidance.

**Perk1961** · 03-29-2015, 09:32 PM

Thanks for clarifying. It will help me with future posts.

sum ifs with date range and multiple criteria-V2

LinkBack

Thread Tools

Rate This Thread

Display

sum ifs with date range and multiple criteria-V2

Re: sum ifs with date range and multiple criteria-V2

Re: sum ifs with date range and multiple criteria-V2

Re: sum ifs with date range and multiple criteria-V2

Re: sum ifs with date range and multiple criteria-V2

Re: sum ifs with date range and multiple criteria-V2

Re: sum ifs with date range and multiple criteria-V2

Thread Information

Users Browsing this Thread

Similar Threads

Date Range with Multiple Criteria

multiple criteria within a date range

PLEASE HELP-Lookup with Multiple Criteria,with date range,and multiple results SCHEDULE

Count - multiple criteria, multiple sheets, and date range.

sum multiple criteria date range

Bookmarks

Bookmarks

Posting Permissions