SUMIFS with Multiple Criteria and OR function

Hello,

I am trying to count the number of "sites" in Site Count that have a Projected Contract Sign Date in "Q1-2022" that are a Type of either a "Migration" or "Full Install". Can someone please review my formula below and advise? I am receiving #UNPARSEABLE error message.

=SUMIFS([Site Count]:[Site Count], [Projected Contract Sign Date]:[Projected Contract Sign Date], "Q1-2022", OR(Type:Type,(@cell = "Migration", @cell = "Full Install")))

Thank you!

Find more posts tagged with

Accepted answers

Jeff Reisman

Move your OR function to after the Type:Type range reference, and drop the last parentheses:

=SUMIFS([Site Count]:[Site Count], [Projected Contract Sign Date]:[Projected Contract Sign Date], "Q1-2022", Type:Type, OR(@cell = "Migration", @cell = "Full Install"))

All comments

Jeff Reisman

Move your OR function to after the Type:Type range reference, and drop the last parentheses:

=SUMIFS([Site Count]:[Site Count], [Projected Contract Sign Date]:[Projected Contract Sign Date], "Q1-2022", Type:Type, OR(@cell = "Migration", @cell = "Full Install"))

t.fleischman

It worked! I tried many hours moving the formula all around. lol Thank you!

Jeff Reisman

https://community.smartsheet.com/discussion/comment/315069#Comment_315069

Glad I could 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.