Please help with sumifs when the criteria is check boxes

Shel

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

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