Excel Formula

[Angel_777_1]

Hi. I am using Microsoft® Excel® for Microsoft 365 MSO (16.0.14326.20384) 64-bit.

I want to know if there is a formula that will count how many check boxes that are "checked" in a range of particular cells and return the sum to a single cell. If there is, how would I write the formula? 

Does the actual "Check Boxes" need to be inserted in the cells in a certain way in order to use it as criteria? Or??

Any help would be much much much appreciated!

I've attached a screen shot of my worksheet.

Thank you in advance for your help.

Angel_777_1

[#2]

@Angel_777_1 

Select one of the cells with a ticked check box.

Click in the formula bar and select the character you see there.

Copy it (Ctrl+C).

Now select a cell where you want a formula to count the check boxes.

Start entering the formula

=COUNTIF(range_to_count, "

where range_to_count is a range with check boxes.

Press Ctrl+V to paste the character you copied.

Finish the formula by typing ") so that it looks like

=COUNTIF(range_to_count, "c")

where c is the pasted character. Press Tab or Enter to confirm the formula.

[#3]

@Angel_777_1 

If the check boxes are to be any more than a decorative feature, it is normal to link them to a cell that will show TRUE/FALSE depending upon the state of the check box.  The linked cell is often chosen to be the one that is hidden by the overlying control.

Assuming the cells form a named range, then

= COUNTIFS(linkedCells, TRUE)

will provide a count of checked boxes.