You will need VBA code to do this.

Personally, i think a a "better" solution is to use Data Validation with
YES/NO (or Y/N)options and then use (for example) SUMIF to calculate number
"checked" i.e answer of "YES" (or "Y")

=SUMIF(A2:A100,"Y")



"Arfa" wrote:

I would like to total the number of check boxs in a column, that have been
checked.

Using Excel 2003

Thanks
AL