analysis of data entered on excel questionnaire format

[Guest]

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
questionnaire:-

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

 

[Guest]

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
questionnaire:-

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

Suggest you paste your list of possible answers and their appropriate
weighted scores in an area below your questionnaire including one 'Make a
selection' score = 0. In cells B1000:C1007
Format your answer cells alongside your set of questions using the - Data -
Validation function, Validation criteria - Allow: List Source: e.g.
=$B$1000:$B$1006
Scoring your responses alongside your responses. Use
=VLOOKUP(C4,I$1000:J$1006,2,FALSE) Total the answers for your overal scoring
report.

You can preset your questionnaire's answers to 'Choose option' giving you an
initial total score of zero. By using Format, Conditional Formatting, you
can format your answers to be the colour red if they equal "Make a selection"
and when a response is provided the colour changes to black.

Hope this helps you.
(e-mail address removed)