You could use code that would inspect the checkboxes, but maybe you could just
use a linked cell for each checkbox.

If you do it nicely and put the linked cells in the same column, you could use:

=countif(a1:A10,true)

If you wanted to use code, you'd want to share where those checkboxes are--on a
userform or a worksheet. And if they're on a worksheet, are they from the Forms
toolbar or from the Control Toolbox toolbar?

Liz wrote:

If I use checkboxes for different types of defects, can I then create a
formula to add up what is checked?

Thanks,
Liz

--

Dave Peterson