SUMIF multiple criteria in other columns

Hi! I need help, I am trying to SUMIF the cost for those HC that are "FTE' and Offshore". I am trying this formula, but is not working.

=SUMIFS([Type of HC]1:[Type of HC]40, "FTE", [On/Offshore]1:[On/Offshore]40, "Onshore", [FY22 P1 July]1:[FY22 P1 July]40)

Thank you!

Find more posts tagged with

Accepted answers

Paul Newcome

The syntax for SUMIFS is different from the SYNTAX for SUMIF. Since you are using SUMIFS you need to enter the range to sum FIRST then follow it with your range/criteria sets.

All comments

Paul Newcome

The syntax for SUMIFS is different from the SYNTAX for SUMIF. Since you are using SUMIFS you need to enter the range to sum FIRST then follow it with your range/criteria sets.

Dayana

Thank you for your help, it worked perfect!

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