Check data then checked data autosummed

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

Hi Ron - thanks so much for taking the time to help. That indeed would work as all I need do is put the y in the cell and the calculation should correspond accordingly.

I have given it a trial run but I am missing something and I am not sure what - I have attached a spreadsheet in excel 2013 format. Would you be kind enough to take a look and let me know where I am going wrong?

All I am getting is a 0 total.

Excel sample.xlsx

Minor mistake, the formula should be "=SUMIF(F5:F12,"y",E5:E12)".

Hi Ron and Pooja,
A BIG THANKS!! It works a treat. You've made me very happy today. Thanks again. (I need to figure out now how to mark this post as answered)
Shaun in Sydney.