Tick Boxes

  • Thread starter Thread starter ALANBATESON
  • Start date Start date
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
 
Hi Alan,

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

Dave M
 
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??????:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count ticks in boxes 2
Show todays date if ticked 2
how do you insert a tick in excel document 3
MessageBox with tick box 3
Can't view Google Maps in 3D anymore? Here's the fix. 2
Making a "Check Box" Larger 1
I can no longer 'drag and drop' text. 6
Excel Finding rulers in Excel 2007 0

Back
Top