SUMIFS Issue

TroyT

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")))

Paul Newcome

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")

TroyT

Side note, if I do just one of the two criterion ranges, it works fine. just can't get both to work.

Paul Newcome

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")

TroyT

It was giving me an "Unparcible" error, but the above worked. Thanks Paul, you crush it!

Paul Newcome

Happy to help. 👍️