Add values to answers of choice on microsoft 365 individual account

[JoondalupPsy]

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

2 Applied to me to a considerable degree, or a good part of time

3 Applied to me very much, or most of the time

From these 21 questions, some are related to anxiety, others to depression and others to stress.

When an individual replies to the questionnaire and I open excell with the results of the response, I want excell to show me the result of the questions according to those 3 categories, x amount of stress, x amount of anxiety and x amount of depression.

Now i am aware that one of the steps to do that is to add "value" to each answer, however my forms does not have that option.

My account is individual. Could that be the reason?

Otherwise, what are my options?

Thank you.

[#2]

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

[#3]

@JoondalupPsy if your Microsoft account has access to Power Automate then you could create a flow to save the form submissions to a SharePoint list. You could then either do the calculations there with a calculated column or do the calculations in the flow itself.

Rob
Los Gallardos
Microsoft Power Automate Community Super User