This guide shows how to perform calculations using Input Table and Form Calculation. Input Table can be found under the Basic tab in Form Elements.
To perform calculations with Input Table
- In the Form Builder, select your Input Table’s gear icon to open properties.
- In the properties panel on the right, go to Options at the top.
- Enter your calculation values according to your table’s dimensions.
Separate the values with commas for columns and break lines for rows.
Note
The Calculation Values option works with radio buttons and checkboxes. See Input Types for more information.
- For the calculations, add a Form Calculation widget to your form.
- Select the widget’s wand icon to open settings.
- In the settings panel on the right, select Add Field, then choose your Input Table.
- Choose your table’s sub-fields to use in your calculations, then select Done at the bottom.
This will add the sub-fields in the calculation editor without operators. Sub-fields are either the rows or cells in your table, depending on the input type.
- Complete your formula in the editor, then select Save at the bottom once you’re done.
Here’s a demo form to see what it looks like. To learn more, see How to Perform Form Calculation Using a Widget.
Send Comment:
26 Comments:
November 26, 2025
I am using the form calculation widget, there are 80 sub-fields. But the window can show only 73 sub-fields and cannot move to the bottom. So, I cannot save my setting.
October 8, 2025
Hi Jotform Support,
I am creating a finance form to track invoice payments. One invoice may be paid in multiple partial cheques (e.g., 6 cheques for a single invoice).
I need a solution where:
I can enter Invoice No, Invoice Date, Invoice Amount once.
I can enter multiple cheque details (Cheque No, Cheque Date, Cheque Amount) without duplicating fields for each cheque.
I can automatically calculate Delay Days for each cheque (Cheque Date – Invoice Date) within the form.
I can optionally sum all cheque amounts to verify against the invoice total.
Which Jotform widget or setup would you recommend to achieve this?
Thank you.
August 27, 2025
Thank you - that worked a treat....plus I was able to expand on it - I LOVE jotform and the customer support is Excellent!!!!!!! Keep up the great work guys!
June 12, 2025
Buenas tardes
Si requiero tener una calificación final y por sección me lo puede dar esta herramienta
March 3, 2025
How can i recalculate the form if values are changed?
January 8, 2025
Hello. I am trying to calculate a string of items with an existing widget; however, it does not allow me to add to it.
March 30, 2024
Como pegar o valor de duas células e buscar o menor?
March 25, 2024
Hello, how can I make a form with 10 questions, adding the value of 1 to each true or false question, with a condition that if it reaches 7 it says approved. Thank you
March 13, 2024
wie kann man das Alter aus aktuellem Datum und Geburtsdatum berechnen?
August 20, 2023
In a numeric table, how can I count how many sub-fiellds were filled?
August 9, 2023
hello,
I would like to know if the form could take the value of a field from a previous form and extract the difference that is obtained.
July 25, 2023
How to sum up the points allotted against the responses, to collate in the integrated Gsheet?
June 25, 2023
How to handle this type of calculation?
A B C
01. A1 B1 A1+B1
02 A2 B2 A2+B2
03 A1+A2 B1+B2 C1+C2
Thank you
June 25, 2023
How to work this type of work?
C 1 C 2 C 3
R 1 -
R 2 -
R 3 -
-
March 27, 2023
Hello:
I'm using time sheet form template
I need to calculate the sum of hours worked each day for the whole week. (the number of hours worked is a field input by the employee)
How to achieve this?
February 28, 2023
I would like to assign one column as Not Applicable and have any row where a user selects Not Applicable excluded in an average score calculation. Is this possible?
February 6, 2023
great tool
January 16, 2023
bonjour équipe. superbe site. est-ce possible d'avoir une formule dont le résultat des calculs sort brut plutôt que de donner des résultats convertis au supérieur ou à l'inférieur? Merci
December 31, 2022
Hi, if i have form with calculation values applied to each answer, is it possible to total up all the answers then redirect to a different webpage according to the total?
November 29, 2022
How to put default (prepopulate) values in Column 1 and Column 2, the third column is a dropdown, and the forth column is a text input column. Is there a way to accomplish this?
September 20, 2022
How do I make the price automatically populate the cell after the customer selects the quantity of the product?
July 18, 2022
This is so great, but i need to know if its is possible to add formulas in this section like in excel so it calculates automutically?
July 15, 2022
This feature is not working for us. Though it is set up correctly, it will not perform the math function. It is like we are getting an average...
April 18, 2022
The instructions state the following:
Note: Choosing a different input type for the table, like a text box or number text box, if you want your respondents to define values for each cell, will not require you to set calculation values.
If this is the case, what if I want to use the dropdown box, how do I give each of the dropdown box answers a different value? For example I want the following dropdown values to equal the corresponding value.
Not at All - 0
A Little Bit - 1
Moderately - 2
Quite a Bit - 3
Extremely - 4
February 7, 2022
very very nice