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

meb_0101

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?

Andrée Starå

Hi @meb_0101

I hope you're well and safe!

Do you have something on the rows with the formula that we could use to identify them?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!