vba - Add columns selectively in excel? -

say have following data

......................judge 1 | judge 2 | judge 3 | total score

contestant 1.......5.............3..............2 .......

contestant 2.......3.............3..............6........

and want design interface (i guess involve vba, unless can without?) can select judge's scores add up.

so theoretically, there's checklist have

[] judge 1

[] judge 2

[] judge 3

[] select

or something, , if press select all, total score sum judge's scores. if unselect select , select judge 1 , 2, scores total accordingly.

any suggestions?

one way without vba:

.

• make data validation rule first row: "list", source: "selected, not selected"
• total score formula: =sumif(b$2:d$2,"=selected",b5:d5)

total score update every time select or deselect 1 of judges