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

    Is there sum and average functions for the spreadsheet widget?

    Asked by ysites on June 17, 2015 at 08:57 AM
  • Profile Image
    JotForm Support

    Answered by Aury on June 17, 2015 at 10:26 AM

    Yes, it is possible to make sum and aaverage functions for the spreadsheet widget, you only have to include the sum/average formula accordingly.

    Take a look at the following exmple:

    As for instance, you have a spreadsheet of 10 rows and 10 columns, the formulas to get sum of rows from cells C thoroug H will be shown on cell I, the average will be showed on cell J

    To get results on Cells I and J, I used the following formulas.

    i2 = c2 + d2 + e2 + f2 +g2 + h2

    j2 = i2/6

    I hope this information helps.