How to add the total amount values which can be captured on the excel spreadsheet ?

Hi, how do we add the total amount values at the bottom of each column on the export spreadsheet please? 

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.

Hi Chriistian,

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

Unfortunately, you will not be able to do that, however, if you create the Google spreadsheets integration you should be able to add the total calculation for all forms. 

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.