QUESTION ABOUT MS. FORM

Question

Dear Microsoft support team,

Thank you very much for your precious time/advice always.

May I have questions about MS. forms: I have a form like this.

Then I export it to Excel like this. But I have to manually sum total like this:

1)Is there any method to do it in MS form? If "no".

2)Is there any alternative method?

Thank you and I am looking forward to your reply asap.

 Yours sincerely,

Answer 1

Dear Microsoft support team Tina,

Thank you very much for your assistance.

I will ask MS. engineers/professionals of MS. PA Community.

 Yours sincerely,

Answer 2

Dear Cuong Dang Quoc,

Greetings! Thank you for posting in Microsoft Community. We are happy to help you.

As per your description, you created Rating questions with Number symbol in Forms, you want to know if there is any method to automatically sum total in Microsoft Forms.

May I know if my understanding of the scenario is right?

If yes, we're sorry and we're afraid there is no out of box way in Microsoft Forms to achieve this requirement. Currently, we need to use formula in the exported Excel file to get sum total.

We do understand the inconvenience caused and apologize for it.

However, per our search, Power Automate flow may achieve your requirement, here is a similar thread: Solved: Sum form entries for logic? - Power Platform Community (microsoft.com)

If you are willing to know more about flow solutions, considering that we have a dedicated channel Microsoft Power Automate Community, to make sure you get the dedicated assistance, I sincerely recommend you go to that community and post a new question, members and engineers are more professional with this kind of questions and will help you further.

If our understanding of the scenario is different from yours, feel free to point it out, we will continue helping you.

Thanks for your cooperation and understanding! Hope you have a nice day!

Sincerely,

Tina | Microsoft Community Moderator