# 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

#1
June 27, 2016 at 18:27:32
 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")MIKEhttp://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")MIKEmessage edited by mmcconaghy

Report •

Related Solutions

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

Report •