SUMIFS with 3 criteria

Why is this function not working?

=SUMIFS({Mai'23 Datenbank}; {Gruppe Datenbank}; Gruppe@row; {Ressourcentyp Datenbank}; [Ressourcen Typ \[FTE\]]@row); {Priorität Datenbank}; Priorität

With only 2 criteria it works fine but when I add the third criteria smarthsheet will show #UNPEARSEAPLE

I want to SUM FTE (Mai`23 Datenbank) in a specific group, with a specific fte type in a specific project (via priority).

Can you please help me?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

The final range/criteria set should be inside of the closed parenthesis. You are closing out the SUMIFS before adding the final range/criteria set. Try moving that closing parenthesis to the very end of the formula.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.