Scoring a proposal based on a set of criteria

[Rocky1961]

I have a document that is used to review and evaluate proposals. The format for scoring has changed and my thought is that Excel could help in reviewing by taking each Group, which has a set value based on specific criteria in the Group and dividing the total by all the number of criteria elements.

Example:

I have a Group called Related Building Experience and there are 10 items within the Group with a total score of 35. so each items is worth 3.5 points. I want to have a checkbox or something to click at each item to indicate the proposal meets the items requirements and then automatically total the Group in a SUM cell the items checked. Also I would like each item to be controlled so a person cannot select Yes and No.

I have tried checkboxes and buttons but neither seems to be working. Attached is an example of what I have tried and it gets really messed up if I delete the Group Box Name, which I would like to be blank so as to not distract the user.

Rocky

[Croweater]

Assuming you want to keep it as simple as possible (no VBA etc) you could link each check box to a cell and use a COUNTIF formula to count the number checked.