Tick Boxes

A

ALANBATESON

if you have 10 tick boxes running vertically in a worksheet, can you
count how many have been ticked at the bottom??????:p
 
D

davers

Hi Alan,

When you say tick boxes, do you mean either option buttons or chec
boxes?

Dave M
 
E

Edwin Tam (MS MVP)

Let me teach you the following trick

For example, on top of each cell, from A2 to A11, you got one checkbox

You link each checkbox to the cell it is on. For example, the checkbox on top of A2 links to cell A2
Then, change the font color of A2 to A11 to white

Originally, when you link a checkbox to a cell, when the checkbox is checked, the cell will show TRUE. If unchecked, the cell will show FALSE. Changing the cell font color to white is to make those TRUE/FALSE not visible on screen

Then, in cell A12, type the formula
=COUNTIF(A2:A11,TRUE

This will count the number of TRUE in the cells above


----- ALANBATESON wrote: ----


if you have 10 tick boxes running vertically in a worksheet, can yo
count how many have been ticked at the bottom??????:
 
Top