Excel 2007- I have a survey that uses radio buttons (3 choices each answer) to select the answer.?
My trouble starts with assigning values to the answers (Answer 1 is 0, Answer 2 is 1, Answer 3 is 2), so that at the end of each section the total can be automatically calculated to eventually have a final total of all the sections.

My Questions
1. How to assign values to radio button selections
2. Which formula would...