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!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 82 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!