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

    Extracting the total value in the Excel report submissions and get the Sum of it.

    Asked by joepolonsky on July 06, 2015 at 09:38 PM

    IS it possible to see a column that only has the sale price on it and a total of all sales at the bottom.? 

    Page URL:
    http://www.jotformpro.com/form/50086211586958

    Screenshot
    Reports all and a
  • Profile Image
    JotForm Support

    Answered by Charlie on July 07, 2015 at 02:24 AM

    Hi,

    I assume you downloaded the excel report of the submissions? If that's the case, you can use an excel formula to get the last price and calculate it.

    You can try using the functions RIGHT, LEFT or MID combing FIND to extract the Total on a specific column. Here's a guide link that you can refer.

    I can also do some test in my end and will get back with you the results.

    Thanks.

  • Profile Image
    JotForm Support

    Answered by Charlie on July 07, 2015 at 02:45 AM

    Here's a step by step on how I did it in my end. I downloaded your submissions for testing purposes.

    1. First, choose a column where you want to add the "Total" of each submission. Here I'll add it in the "P" column. Here's the function that I will be using:

    =VALUE(MID(K2,FIND("Total:",K2)+6,4))

    I'll add the function in the P2 cell.

     

    2. You'll see that the Total value of that submission is now been extracted, to apply the formula to the other cells, you need to hover your mouse on the right bottom part of the cell box, you'll see that you can drag it like how it is shown in the screenshot below.

    3. After you have dragged it on the bottom part of the last submission, you can now sum all the cells in that column.

     

     

    I hope that helps. Do let us know if you need more assistance on this.

    Thanks.