Solved SUMIF with multiple sum ranges

June 27, 2016 at 17:18:28
Specs: Windows 64
Hi Forum!

I fell ill & been off of work for almost a week, well of course the reporting sat there until I returned (lucky me - not)

=SUMIFS('Raw Data'!O:O,'Raw Data'!W:W,'Raw Data'!AG:AG,'Raw Data'!G:G,"BB Mass",'Raw Data'!M:M,"Triggers")

Can someone assist? Without writing a long explanation of the formula above (because I tend to confuse when I try to explain in detail) What I am having an issue with is this:

I need the sum of O:O, W:W and AG:AG for ONLY BB Mass an Triggers however, Excel is only returning the total for the first sum range O:O and is ignoring the other two (W:W and AG:AG)

Thank you!


See More: SUMIF with multiple sum ranges

Report •


#1
June 27, 2016 at 18:27:32
✔ Best Answer
Excel is only returning the total for the first sum range O:O and is ignoring the other two (W:W and AG:AG)

That is because the =SUMIFS() function has only One Sum Range, but can have Multiple Criteria.

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

So to get your three totals you need something like:

=SUMIFS('Raw Data'!O:O,'Raw Data'!G:G,"BB Mass",'Raw Data'!M:M,"Triggers")
=SUMIFS('Raw Data'!W:W,'Raw Data'!G:G,"BB Mass",'Raw Data'!M:M,"Triggers")
=SUMIFS('Raw Data'!AG:AG,'Raw Data'!G:G,"BB Mass",'Raw Data'!M:M,"Triggers")

MIKE

http://www.skeptic.com/


Report •

#2
June 27, 2016 at 18:52:59
That make sense - how can I combine them ALL into one formula? Or how am I to combine them all?

Report •

#3
June 27, 2016 at 18:55:02
=SUMIFS('Raw Data'!O:O,'Raw Data'!G:G,"BB Mass",'Raw Data'!M:M,"Triggers")+
SUMIFS('Raw Data'!W:W,'Raw Data'!G:G,"BB Mass",'Raw Data'!M:M,"Triggers")+
SUMIFS('Raw Data'!AG:AG,'Raw Data'!G:G,"BB Mass",'Raw Data'!M:M,"Triggers")

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

Related Solutions

#4
June 27, 2016 at 18:57:48
Thank you!!!!!!! It worked and well!!!

Report •

Ask Question