Using Count Formual with checked boxes

  • Thread starter Thread starter Annie
  • Start date Start date
A

Annie

Hello,

(2nd Posting -- just in case the first request did not Post correctly)

I have a form in Excel that has boxes within cells F8:F27. When you click
on the box, it inputs a check mark. I would like to use a formula to count
all boxes that are checked (actual check mark)

Can anyone help me, please?
 
Hi,

If the boxes have been created through the option in the Forms menu, then
one can supply a cell link cell in the Format control box. The cell link
will display as TRUE when the box is checked. Then one can use the
=countif(range,true) to count the checked boxes

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Formula to count the number of boxes checked 1
Count Formula 1
Copy and move check box (check boxes) with new cell link? 1
Excel Count Cells That Contain Text With "?" 0
Yes - No Interactive Text Box 1
Check Boxes 5
Check Box in Excel 2
How do I make a box with a check mark when clicked? 4

Back
Top