Please help with sumifs when the criteria is check boxes

Hello,

I am trying to sum a column if none of the checkboxes are checked. I have 9 checkbox columns that need to be factored in. I can get one column to work, but when I start adding more columns it will not work. I think I am missing something simple because I am frustrated.

My single column formula is =SUMIFS([RMA request $]@row, [Adjusted RMA]@row, true)

I have changed the true to a 1 as well.

In the end, I just need the "RMA Requested $" to be in the last column if nothing is checked off.

TIA

Find more posts tagged with

Accepted answers

All comments

SmartWay360

Hi,

What about using a Report. There you can filter out all the checkboxes that are checked and use Summarize (SUM) to get the value of RMA requests.

Will it work?

Best,

Beata

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.