How to mark some columns as ignored for calculations Numbers? I'm creating a template on Numbers and I would like to know if there is a way for the formula to ignore, or skip over some cells or even entire columns. I need these columns for some calculations, but need them to be overlooked for others. The catch being, which column will have to be skipped over will be different every time.

Maybe there is a way to "mark" a column to be ignored, with the help of a checkbox, perhaps?

Or is there an even easier, more obvious way that has eluded me?
In practice, you could sum each column and then sum just the the sum row.

That way, you can delete the sum of the column to be skipped when needed and it should be clear about which of the columns is ignored.

A more general solution will be tricky since it's programming in conditional values or conditional functions that are much harder to maintain, debug and be confident your math is correct as you use the tool over time.