How do I count a tickbox in a spreadsheet?

  • Thread starter Thread starter Rossy_t42
  • Start date Start date
R

Rossy_t42

Can someone help, need to know if, and if so how, you can count a tickbox in
a spreadsheet. For example, if someone ticked yes I would like a value of 1
recorded
 
Hi,

It depends which type you used.
From the 'Forms' toolbar
Right click the checkbox
Format Control
Control tab
Enter a linked cell (Say B1)
Click OK

From the 'Control' Toolbar
Right click it while in design mode
Select 'Properties'
Scroll down and find 'Linked Cell'
Enter a cell reference (Say B2)
Click Ok

Now if either are checked the word TRUE will appear in the linked cell which
you can count with

=COUNTIF(B1:B17,"=TRUE")

You can hide the column with True/False in

Mike
 
Back
Top