Using Count Formual with checked boxes

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?
 
A

Ashish Mathur

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
I want to be able to count the number of checked boxes in a form? 4
Copy and move check box (check boxes) with new cell link? 1
Yes - No Interactive Text Box 1
In Excel, how to count a list of check boxes some are checked? 8
How do I make a box with a check mark when clicked? 4
how to calculate a count of checkboxes that have been checked 1

Top