Forum Discussion
Add values to answers of choice on microsoft 365 individual account
Hi. I'm trying to create a questionnaire on forms. This questionnaire has 21 questions, each has the same 4 answers: 0 Did not apply to me at all 1 Applied to me to some degree, or some of the time...
Hi,
I don't know what exactly you want to achieve, but I can think of two things:
1/ to compute points per respondent / patient
You can do that on copy of the resulting sheet - use Ctrl+h to replace
"Did not apply to me at all" with 0
"Applied to me to some degree, or some of the time" with 1
"Applied to me to a considerable degree, or a good part of time" with 2
"Applied to me very much, or most of the time" with 3
Then calculate the SUM
2/ Use COUNTIF to count how often each of the answers has been given
Pivot tables (a third possibility) won't work in this case.
Kind regards
Hans
I don't know what exactly you want to achieve, but I can think of two things:
1/ to compute points per respondent / patient
You can do that on copy of the resulting sheet - use Ctrl+h to replace
"Did not apply to me at all" with 0
"Applied to me to some degree, or some of the time" with 1
"Applied to me to a considerable degree, or a good part of time" with 2
"Applied to me very much, or most of the time" with 3
Then calculate the SUM
2/ Use COUNTIF to count how often each of the answers has been given
Pivot tables (a third possibility) won't work in this case.
Kind regards
Hans