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?