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

Find more posts tagged with

Formulas

Accepted answers

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

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.