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

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

    Asked by toolmantim 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
    JotForm Support

    Answered by Kevin_G 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.