I am currently trying to analyse data from a questionnaire. The
questionnarie is displayed on excel. There are a series of questions on the
left hand side, & the options listed below are along the top of the
questionnai-

6 Not at All
5 A little of the time
4 Some of the time
3 Quite often
2 Most of the time
1 All of the time

I have indicated the marks given for each of these options above (i.e. 1-6).

i.e. Each time the response 'Not at all it' is given the client will receive
6 marks.

Can i enter a formula, for example, onto my excel questionnaire, so that
each time the client answers 'Not at all' excel will automatically allocate
the appropriate points for that question. At the end of the questionnaire i
want to find out what the total marks are for that particular client.

Many thanks,

Mel