How to Calculate the Sum of Specific Fields

December 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

  1. In Tables, open the column’s Add Summary menu at the bottom.
  2. Select Sum from the menu.

The sum should appear at the bottom of the column.


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

  1. In Tables, add or insert a new column.
An arrow pointing to the Add heading, to add a column, in Jotform Tables
  1. In the Add a New Column dialog, go to Formula at the top.
  2. Select Advanced Formula, then Next in the lower-right corner.
Arrow guides to add an Advaned Formula column in Jotform Tables
  1. Enter your desired column name, then select Next.
Setting up the Advanced Formula's column name in Jotform Tables
  1. 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}....
  2. Once you’re done, select Create Column at the bottom.
An addition operation in Jotform Tables' Advanced Formula

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

You can even aggregate the Advanced Formula column as shown here.

Contact Support:

Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:

Support Forum:

Contact Jotform Support:

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


  • Vivienne van Beusekom - Profile picture