- JotForm SupportKevin_GAnswered 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.