Count Formula - Count Ticks
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)
LittleAnn wrote:
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.
--
Dave Peterson
|