Count and multiply the result of checkbox

[zeez36]

I need a formula that counting the checkbox, when it checked, and then multiply the result in the grades.
Ex. The grade for Excellent is 5, so if I checked 2 checkboxes, then the result will be 10
Ex. The grade for Fair is 2, so if I checked 3 checkboxes, then the result will be 6

Please check the attached file

[benishiryo]

hi zeez36. right-click a checkbox & Format Control. Assign a cell link to each checkbox (yes, pretty troublesome). that's the way formulas work with Form Controls. so if your cell link for all "Poor" checkboxes are in D25:D33, do this formula in D21:
=COUNTIF(D25:D33,TRUE)*D$19

[zeez36]

Thanks a lot, solved

[zeez36]

Please, I have another question

Can I put an If condition in a cell, that if he found the checked box in the first cell (poor), the result is 1, and if he found the checked box in the 3rd cell (good), put 3, and so on