SUMIFS with OR (Sheet Summary)

Matthew Bertucci

I'm trying to create a sheet summary formula

Sum up a Column -Total Save

Status column is "Orange"

And

Hierarchy Level 4 - SubDivision is "Solutions"

And either

FY23 into FY22 Pull Frwd (TM Notify) box is checked

Addition to Pull Frwd box is checked

=SUMIFS([Total Save]:[Total Save], OR([FY23 into FY22 Pull Frwd (TM Notify)] = 1, [Addition to Pull Frwd (TM Notify)] = 1), Status:Status, "Orange", [Hierarchy Level 4 - SubDivison]:[Hierarchy Level 4 - SubDivison], "Solutions"))

I keep getting unparseable result. Does is have to do with the fact that I'm in "sheet summary"? I've tried is many different ways and now I'm stuck. Any help would be much appreciated. 😀

Find more posts tagged with

Accepted answers

Paul Newcome

You are going to need to use a SUMIFS for each of the different checkbox columns and then add those SUMIFS together.

=SUMIFS([Sum Column]:[Sum Column], [1st Checkbox]:[1st Checkbox], @cell = 1) + SUMIFS([Sum Column]:[Sum Column], [2nd Checkbox]:[2nd Checkbox], @cell = 1)

All comments

Paul Newcome

You are going to need to use a SUMIFS for each of the different checkbox columns and then add those SUMIFS together.

=SUMIFS([Sum Column]:[Sum Column], [1st Checkbox]:[1st Checkbox], @cell = 1) + SUMIFS([Sum Column]:[Sum Column], [2nd Checkbox]:[2nd Checkbox], @cell = 1)

Matthew Bertucci

That worked! 😀

I utilize your answers all the time and really appreciate it!

Thank you Paul!

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.