Help with Sumifs

MoJones

Hello. Hope everyone is well. I'm having issues with a =SUMIF OR =SUMIFS formula

=SUMIFS({Fed Admin FTE Usage}, >0, {Employment Status}, "On-Board")

I'm getting invalid operation. Please help.

Find more posts tagged with

Accepted answers

All comments

MoJones

Ok. I figured this one out - =SUMIFS({Fed Admin FTE Usage}, {Employment Status}, "On-Board")

But now I have another issue =SUMIFS({Program FTE Usage}, {Victims of Torture}, {Employment Status}, "On-Board")

Any ideas?

Paul Newcome

You are missing the criteria for the second range:

=SUMIFS({Program FTE Usage}, {Victims of Torture}, {Employment Status}, "On-Board")

MoJones

Trying to add program FTE Usage and Victims of Torture but only if the employment status is "On-Board" not sure what I'm missing here.

Jeff M.

Hi,

This method might work for you as well. Hope that helps!

=SUMIF({Employment Status}, "On-Board", {Program FTE Usage}) + SUMIF({Employment Status}, "On-Board", {Victims of Torture})

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.