Is there a way to count checked checkbox?

[Mr.Castle]

From C4:C20 i have a range of cells with checkbox, is there a way to count only checked checkbox?

[sktneer]

Maybe this...

Please Login or Register  to view this content.

[benishiryo]

are you using Form Controls or ActiveX Controls? to check, right-click the cell and see if you see Properties. If you see it, it's the latter.

and it depends on where you store the Cell Link (if you even put it). If you right-click a Form Control and click Form Control option, you see a Cell Link box. since all these checkboxes are floating in Excel and not linked to any cells, you can input the outcome in a cell. for eg, cell A1. when you do a check, you see cell A1 turn TRUE.

for ActiveX Controls, you need to right-click and choose Properties. There is a LinkedCell input. this time, you have to input worksheet reference as well:
Sheet1!A2

then just count those which turns TRUE. for eg.
=COUNTIF(A:A,TRUE)

[Mr.Castle]

I am using form control.

[Mr.Castle]

Thank you benishiryo , Your instructions worked.