SUMIFS Issue
I have a fairly straightforward formula that i cant get to work, driving me crazy! I typically prefer Sumifs over Sumif but currently I am summing a kpi column of numbers if two additional columns (both Text/dropdown (single Select format) report a specific set of words. what am i missing!?! Thanks in advance.
=SUMIFS([KPI Hour Left (Formula)]:[KPI Hour Left (Formula)], [Project Type]:[Project Type], (@cell = "Team - Production", Status:Status, (@cell = "Subscription - Active")))
Best Answer
-
Are you getting an error or unexpected results? I notice some misplaced parenthesis, so I imagine probably an error? Try the below.
=SUMIFS([KPI Hour Left (Formula)]:[KPI Hour Left (Formula)], [Project Type]:[Project Type], @cell = "Team - Production", Status:Status, @cell = "Subscription - Active")
Answers
-
Side note, if I do just one of the two criterion ranges, it works fine. just can't get both to work.
-
Are you getting an error or unexpected results? I notice some misplaced parenthesis, so I imagine probably an error? Try the below.
=SUMIFS([KPI Hour Left (Formula)]:[KPI Hour Left (Formula)], [Project Type]:[Project Type], @cell = "Team - Production", Status:Status, @cell = "Subscription - Active")
-
It was giving me an "Unparcible" error, but the above worked. Thanks Paul, you crush it!
-
Help Article Resources
Categories
Check out the Formula Handbook template!
