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"...
Make sure you are counting the True instances for the cells which are linked to the CheckBoxes and as per your formula A2:A5 should be linked to the four CheckBoxes. Check linked cell property for each CheckBox and see if they are linked to the correct cells.
Subodh_Tiwari_sktneerthanks a lot. I could solve it by changing the language of parts of the formula (see above).
No problem! Glad your issue has been resolved.
