Forum Discussion
Angel_777_1
Sep 22, 2021Copper Contributor
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...
PeterBartholomew1
Sep 22, 2021Silver Contributor
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.