counting checkboxes
The easiest way is to link the checkbox's to cells in your sheets. If the
checkboxes come from the control toolbox then add a reference to the
LinkedCell property (put the sheet in design mode and right click the
checkbox and select Properties). If the check boxes are from the forms
toolbar then right click the check box and select Format control | control.
Once you have linked each checkbox to a cell you can do a simple countif
function to get the number of checks...
--
HTH...
Jim Thomlinson
"Manny" wrote:
Is it possible to count up the "true" values of a series of checkboxes? If
so, what is the formula?
--
Thanks,
Manny
|