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
Comments
Post a Comment