Count Formula - Count Ticks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 

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
Excel Query 0
How do I count a tickbox in a spreadsheet? 1
COUNTIF-look for dates in range 4
Count if with multiple criteria 3
Pivot Tables - Count Numbers vs. Count 1
Excel Formula - Count Dates from another Sheet 8
counting ticked check boxes 1

Back
Top