Count Formula - Count Ticks

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

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

Top