Count Formula - Count Ticks

L

LittleAnn

Hi I want to set up a count formula in a spreadsheet to allow to count a
number of instances where people have ticked the boxes in the spreadsheet.
 
D

Dave Peterson

It depends on how they created the tick.

If they used a checkbox, you could use a linked cell for each of those
checkboxes and then

=countif(a1:a10,true)

If you used a format & font that looked like a checkbox when there was something
in that cell:

=counta(a1:a10)
 
Top