Sum based on the status of a check box

Nancy Heater

Hello!

I have found another discussion on this topic, but it didn't quite get me where I needed.

For the Sheet Summary data, we are looking to see the total of all of the kits needed and to have this number continue to reflect the "current" need as lines get marked complete ... so we only want it to count lines that are NOT checked as Complete. Sum of Kit #1, without anything marked as Complete.

Link to my test sheet is here: https://app.smartsheet.com/b/publish?EQBCT=2a8f00cc49eb4021916f06af91e28095

Thank you in advance for the assistance!

Mark Cronk

Hi @Nancy Heater ,

I corrected the formula in your test sheet. You need to use SUMIFS looking for the Complete range to be 0, or unchecked.

Mark

Mark Cronk

Hi @Nancy Heater ,

I corrected the formula in your test sheet. You need to use SUMIFS looking for the Complete range to be 0, or unchecked.

Mark

Nancy Heater

=SUMIFS([Kit #1]:[Kit #1], Complete:Complete, @cell = 0

@Mark Cronk - thank you, thank you, thank you!!! I have been stumped on this for days!

EDIT - I tried this in another sheet and found I had to also put the Complete in brackets:

=SUMIFS([Kit #1]:[Kit #1], [Complete]:[Complete], @cell = 0)