Subtracting checked rows from a total

I'm trying to figure out how to create a formula that would subtract checked rows from a total. For example in the photo I have the 4 items on the right summed in the upper left to $16,000. Every time i check a box and get a strikethrough, I'd like the total to adjust to the remaining items. Thanks!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!