# SUMIF positive numbers with multiple criteria

1. ## SUMIF positive numbers with multiple criteria

I need help with the following formula.

=SUMIFS(Hours_RAW!G:G,Hours_RAW!E:E,F325,Hours_RAW!B:B,G325)

The Hours_Raw is a different sheet within the same workbook. Right now, it's set to sum all amounts in that column, which isn't the accurate number I need. I need to sum the amounts in Column G of that sheet, while still being able to only have it pull the amounts when the name in column E is the same as in F325 and when the date in column B is the same as in G325

Any help would be appreciated. I'm not advanced with formulas as i'm still learning more than just the basic ones.

2. ## Re: SUMIF positive numbers with mulitple criteria.

That should do what you describe, unless the value in F325 is not found in column E OR if the date is G325 is not found in column B. There are many reasons why the names might not match, although they may look the same - you could have leading or trailing spaces or other non-printable characters in F325 or in column E values. The date in G325 might be a text value that looks like a date, whereas column B contains proper dates (or vice versa), or it might be that the dates in column B are actually date/times which are formatted to show only the date part.

It is impossible for us to know which of these (or something else) is the case without seeing your data, so please upload a sample Excel workbook as described in the yellow banner at the top of the screen.

Hope this helps.

Pete

3. ## Re: SUMIF positive numbers with mulitple criteria.

I should have clarified a little better in my original post. The formula in it's current state works. I just need to modify it or add to it in some way so that any negative numbers aren't calculated in that sum. I'm thinking a ">0" needs be added in somewhere but each time I try to add it in, I get an error. It's very possible i'm not adding in the right spot or don't have all the right quotations, commas, etc within the formula.

4. ## Re: SUMIF positive numbers with mulitple criteria.

Okay, try it this way:

=SUMIFS(Hours_RAW!G:G,Hours_RAW!E:E,F325,Hours_RAW!B:B,G325,Hours_RAW!G:G,">0")

(changes in red).

Hope this helps.

Pete

5. ## Re: SUMIF positive numbers with multiple criteria

I've uploaded the excel file in question. The formula is in Column D on the "safety_summary" tab.

6. ## Re: SUMIF positive numbers with mulitple criteria.

Thank you Guru, that did it! Much appreciation for your help! You've made my life much easier now.

8. ## Re: SUMIF positive numbers with multiple criteria

In addition to marking the thread as SOLVED, you might also like to know that you can show your appreciation directly and thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)