Microsoft Excel Tips and Tricks
In this Microsoft Excel video tutorial I demonstrate two ways of counting or summing checked checkboxes. The first method uses checkbox controls and is the method to use if you have a small number of checkboxes. The second method uses the CHAR function and a VBA macro; this method is useful if you need a large number of checkboxes.
Credit Chester Tugwell