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.


  • Profile Image

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

    Asked by Lossuenos on July 08, 2016 at 02:59 AM

    Hi, we tried the exporting the spreadsheet file, but we have to do the manual calculations on the total value each time. is there a function where we can add "total values amount" on the exported spreadsheet on each column ?

     

    can someone please advise? 

    example :

    total no of participants = values

    Total payable amount = values

    total balance outstanding = values

    total males = values

    total females = values

     

    many thanks, Lily

    excel amount Excel spreadsheet
  • Profile Image
    JotForm Support

    Answered by Chriistian on July 08, 2016 at 07:15 AM

    You will need to have a calculation field in your form to compute for the total values of your form. You can just hide the field so user will not be able to see the field. You can check this article for more information: How to Perform Calculation in the Form. Once you have this field, it will also be included on the spreadsheet when you download the submission.

     

    Do let us know if you need further assistance.
    Regards.

  • Profile Image

    Answered by Lossuenos on July 13, 2016 at 05:50 AM

    Thank you, will try again. Kind regards 

  • Profile Image

    Answered by Lossuenos on July 16, 2016 at 09:41 AM

    Hi, as mentioned on earlier (other message) this one is only for single form entry..not on the exprted excel spreadsheet, I need the total value for each items.  kindly advise.  thanks.

  • Profile Image
    JotForm Support

    Answered by Welvin on July 16, 2016 at 12:35 PM

    It's not possible, unfortunately. You'd like to get the total of all the submissions which is stored in one column. As suggested by colleague Boris, you'll need to do it manually. That should take you a minute. 

    Here's a guide from MS Office:

    https://support.office.com/en-us/article/Use-AutoSum-to-sum-numbers-543941e7-e783-44ef-8317-7d1bb85fe706