The second formula you gave me worked. Thanks a million

"Dave Peterson" wrote:

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