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

  • Profile Image
    joepolonsky
    Asked 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.? 

  • Profile Image
    Charlie
    Answered 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
    Charlie
    Answered 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.