How to exclude cells with formulas when using SUM formula for column totals

I'm wanting to use a formula to get the total $ amount for 2 columns in a sheet. The problem is, both columns contain cells w/ SUM formulas. I do not want to use or include these existing formulas in my new formula. There are 4 cells with formulas I want to exclude and some cells with text.

Is it possible to get the total for these columns while excluding the cells that have existing formulas?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!