How to Calculate the Sum of Specific Fields

Last Update: June 7, 2023

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

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

Enter your desired column name, then select Next.

Setting up the Advanced Formula's column name in Jotform Tables

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.