Calculate the sum of multiple fields using Form Calculation widget

  • Rachel Hetrick
    Answered on February 23, 2023 04:41 AM

    Is there really no simple sum function? I'm going to be including an input table in my form with the option to fill in up to 60 lines and would like to have the total from one column automatically calculated. Do I really have to insert those 60 fields and then individually add a + between each one? I found your platform when I was searching for tips on creating a form in Excel because it was being advertised as an alternative. But this is a pretty big limitation. If not for the need to put info in a table and have one of the columns automatically calculated, I would just make my form in Adobe or Google forms...

  • Annaliza Ortiz JotForm Support
    Answered on February 23, 2023 05:04 AM

    Hello Rachel,

    Thanks for reaching out to Jotform Support. Yes, that is correct if you want to get the sum of the fields will need to use the form calculation widget and add a + sign for each field. Check out the screenshot below:

    b577FHX Screenshot 10

    I suggest checking this guide Form Calculation: Math Function Reference.

    Reach out again if you have any other questions.

  • Hetrick_Rachel
    Answered on February 23, 2023 01:26 PM

    I've checked that and all the other possibly related articles I could find in your help center. I just found it kind of hard to believe that you have all these much more complicated functions built in but not a sum. I'll take your response as confirmation that you do not offer that function, though. Thankfully I found a different solution already, embedding an Excel table in an Adobe form, so I won't need to waste my time adding 60 fields to a confusing widget and then tediously clicking through and adding 59 + signs.