How can I create a macro "button" over a series of columns that will cause a
formula in another part of the sheet to ignore the value that the column
calculates to?
i.e.

X X X
20 60 9
40 50 21
_______________
60 110 30 =200

I would like to click on the button (represented by the X) or perhaps more
than one button, have the button change appearance and then that column
total wouldn't be used to calculate the answer (200)

Does that make since?