SUMIFS - multiple criteria refrencing another sheet

Alyssa_OBrien

Hello - I need help with a SUMIFS formula referencing another sheet.

I would like it to sum the tech count column if the request type is "FSA" and the FW01 column is "true"

Here is my formula that is currently not working:

=SUMIFS({Tech Count Range 1}, {Tech Count Range 2}, "FSA", {Tech Count Range 3}, "true"})

Tech Count Range 1 = Tech Count column ( value to be summed)

Tech Count Range 2 = Request Type Column

Tech Count Range 3 = FW01 Column

Thank you!

Find more posts tagged with

Formulas

Accepted answers

All comments

Samuel Mueller

@Alyssa_OBrien if the formula you have there is an exact copy then you have an extra "}" after true that shouldn't be there. try

=SUMIFS({Tech Count Range 1}, {Tech Count Range 2}, "FSA", {Tech Count Range 3}, "true")

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.