What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
It seems you have created two different thread for the same issue. I have already responded to your other thread. You can check the thread here: https://www.jotform.com/answers/878109. We will attend to your concern on the other thread.
We have tried the settings but it only works for the form total amount. but it doesn't work on the total value amount for (Exported) excel file as shown on my picture above..
after exporting the excel file, I would like to see the total values at each column.
please advise if this is possible. thanks
Create a new column for the calculation in the part of spreadsheet that will not be overwritten when users submit the form.
The important part when using Google spreadsheets with custom fields is to avoid changing the fields that are generated.
Let us know if you need more information.