Sum when the Checkbox is not check.



I am currently using a formula to sum the amount in the value cell.

=SUMIFS([Amount after Change]:[Amount after Change], Status:Status, "OUT - to the next month")

I want to extend the formula to only count when the Archive checkbox is not checked. Thanks for your help.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!