With Jotform Tables, you can easily get the sum of your form fields using the summary feature and Advanced Formula.
To get the sum of fields in a column
- In Tables, open the column’s Add Summary menu at the bottom.
- Select Sum from the menu.
The sum should appear at the bottom of the column.
Note
Aggregations are available on the following column types: Number, Spinner, Star Rating, and Advanced Formula. For other column types, use Advanced Formula to reference their numeric values where aggregations are supported.
To get the sum of fields in a row
- In Tables, add or insert a new column.
![An arrow pointing to the Add heading, to add a column, in Jotform Tables](https://www.jotform.com/blog/wp-content/uploads/2023/04/jotform-tables-add-column-type-min.png)
- In the Add a New Column dialog, go to Formula at the top.
- Select Advanced Formula, then Next in the lower-right corner.
![Arrow guides to add an Advaned Formula column in Jotform Tables](https://www.jotform.com/blog/wp-content/uploads/2023/04/tables-add-new-column-advanced-formula-min.png)
- Enter your desired column name, then select Next.
![Setting up the Advanced Formula's column name in Jotform Tables](https://www.jotform.com/blog/wp-content/uploads/2023/04/tables-add-new-advanced-formula-column-name-min.png)
- Now, create a formula to get the sum of your columns using the addition operator in the editor. For example,
{Column 1}+{Column 2}+{Column 3}...
. - Once you’re done, select Create Column at the bottom.
![An addition operation in Jotform Tables' Advanced Formula](https://www.jotform.com/blog/wp-content/uploads/2023/04/tables-advanced-formula-sum-column-min.png)
To learn more, see Using Advanced Formula. The new column should now appear on your table showing the results of your formula for each entry.
![The Total column created with Advanced Formula in Jotform Tables](https://www.jotform.com/blog/wp-content/uploads/2023/04/tables-advanced-formula-total-column-min.png)
You can even aggregate the Advanced Formula column as shown here.
Send Comment:
3 Comments:
29 days ago
Thanks for the knowledge its very helpful.
36 days ago
I need your assistance; I am confused on how to set up a forum.
120 days ago
Can someone help me i wait very long now