Forum Discussion
please help getting this excel formula right [counting checked boxes]
Hi there, could someone help me out here: I created a list in excel with check boxes and would like to count only the checked boxes. Now here's the problem with the boxes as they are shown as "true"...
I believe you formatted the checkbox to determine which cells the values will be linked to as highlighted below:
In my case, the values based on checkbox selection are reported in cells M1 to M6, hence, the formula I used was based on the TRUE/FALSE reported based on checking or unchecking the boxes.
The formula used was
=COUNTIF(M1:M6,TRUE)
See attached the worksheet for guidance and do let me know if any clarification is required.
Note that in your own case, if you still want to use A2 to A5 in your formula, ensure the checkboxes are linked to the cells.
Cheers
Emmanuel