I am designing a spreadsheet in Excel 97 that is going to be a survey. Answers to the questions are numbers and I want the user to select a number with a click of an option button. Then I want the answers to the questions totalled. I assume I'd add the button then assign a value (not sure how) then somehow total the values. Any help would be appreciated.