Hi Guys
I've done my research and still not sure what to do. Best I've come up so far is to use validation but it's beyond me.

I need this
Category Points Yes/No
A not less than 18 and under25 25 Y
B not less than 25 and under 33 30
C Has worked as a mechanic? 10 Y
Total 35
and better formatted in this image:
Clip_14.jpg


So Say a person fits the criteria for Category B they then click the Yes checkbox.

And say they also fit the criteria for Category C they then also click the Yes checkbox.

This gives them a total of 35 points.

I would like the spreadsheet to summarise all the checked data to summarise the total amount of points checked.

I need to know how to create a checkbox to capture the points amount and how to get the spreadsheet to summarise the checked points.

If anyone could help you would make my day!

Thanks in advance.

Cheers