Forum Discussion
Excel Formula
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 particula...
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.