How can I create a form that calculates the collective total value on form

Hello 28061965F,

Unfortunately, there is no tool that can get the value of one submission and add the value to another submission. But you can download the submissions of your form into an excel document and you can then run a formula that will add the values of each. You can check out this guide to know how to get the Excel document of your form's submissions: https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

If I am misinterpreting your inquiry, please let us know.

If I understand you correctly, each question has a "value" and you want to add those values.

You can use the Form Calculation Widget for that.

Help Article: How to Perform Form Calculation Using a Widget

I see that you have already turned on the option to use Calculation Values on the Single Choice fields.

The next step is to add a Form Calculation widget and specify the questions you want to add.

DEMO: https://form.jotform.com/80235417236957

Let us know if you have further questions.

I have changed two fields in the calculation formula from the Text (A-Z) format to the Number (0-9) format, and added the + signs.

Here is a quick animation:

The calculation should be fixed.

Unfortunately, there is no way to automatically assign the calculation values.

Thank you.