MrExcel Publishing
Your One Stop for Excel Tips & Solutions

counting checkbox values


Posted by Cliff Myers on July 28, 2000 9:03 PM

I'm using check boxes in cells I4:I9 and I need cell I10 to display the number of boxes checked times 1.
Please someone explain how to read the values of the checkboxes.


Posted by Celia on July 29, 0100 4:09 AM

Cliff
Check Boxes? Please clarify.
Celia

Posted by Celia on July 29, 0100 4:59 PM


Link each box to a cell in the range I4:I9 and put the following formula in cell I10 :-

=COUNTIF((A1:A5),"True")

Celia

Posted by cliff on July 30, 0100 6:51 PM

Celia,
Thank you, this one worked great.

cliff