Sum based on the status of a check box

Nancy Heater
Nancy Heater ✭✭✭✭
edited 11/23/20 in Formulas and Functions


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:

Thank you in advance for the assistance!

Best Answer


  • Nancy Heater
    Nancy Heater ✭✭✭✭
    edited 11/23/20

    =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)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!