Spreadsheet widget: How to sum columns/rows without entering every single value?

  • Profile Image
    toolmantim
    Asked on January 11, 2017 at 08:56 AM
     Is there any way to get the sum from H1 to H179 .. beside from H1 + H2 + H3 until it reach to H179 ?
  • Profile Image
    Kevin_G
    Answered on January 11, 2017 at 11:32 AM

    Yes, it will be possible to achieve using the sum() function, it will be basically like this: 

    a = sum(b1:b2)

    a = Will be the cell where you want the value to be displayed.

    b1 = Will be the first cell you want to start taking into account for the calculation. 

    b2 = Will be the last cell you want to take into account for the calculation. 

    It needs to be added in the "Default Values" of the widget: 

    Here's an example if you want to take a look: https://form.jotform.com/70104908374959 

    Feel free to clone it: How-to-Clone-an-Existing-Form-from-a-URL

    If you have any question, let us know.