Counting cells that have a checkbox that is marked

I

Inquiry

I am trying to create a formula that will tell me how many check boxes are
marked in a certain column. Does anyone know how to do this?
 
D

Dave Peterson

The easiest way is to assign a linked cell to the checkbox and then look at that
linked cell.

So if you have 10 checkboxes hovering over A1:A10 and have 10 linked cells in
B1:B10, you could use:

=countif(b1:b10,true)

Depending on what checkbox you used (from the Forms toolbar or from the Control
toolbox toolbar), the way you change that linked cell varies.

Forms toolbar checkbox
Rightclick on each checkbox
Choose Format|Control
then Control tab
Then type it into the cell link box.

Control toolbox toolbar
go into design mode (another icon on that control toolbox toolbar)
Rightclick on each checkbox
Properties|LinkedCell
and type it in.
 

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

Automatic indexing in footnotes - solved 0
Create form with checkbox les that expand and collapse sections of the form? 0
Problems created by Recent updates to Outlook 365 0
Formula to count the number of boxes checked 1
WORD VBA Search and switch to advanced ... 1
Count Number of Unique Cells That Don't Have Certain Characters 0
Content Control Box Issue - Please Help! 0
Copy addition formula of non-consecutive horizontal cells 2

Top