If you use the checkbox tool from the Forms Toolbar, you can assign cell links to them (assign C4-C23, respectively to each checkbox). When checked, the cell link value will be TRUE....

Then you can use formula =Countif(C4:C23,TRUE)