How to Get the Sum of Fields in Jotform Tables

November 19, 2024

Whether tracking finances, analyzing survey responses, or managing inventory, you can easily calculate the sum of fields using the summary feature and Advanced Formula in Jotform Tables.

Calculating the Sum of Fields in a Column

To get the sum of fields in a column

  1. In Jotform Tables, open Add Summary at the bottom of the column.
An Add Summary menu in Jotform Tables
  1. Select Sum from the menu.
A Sum option in a Jotform Tables Add Summary menu

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.

The sum will appear at the bottom of the column.

A sum of a column in Jotform Tables

Calculating the Sum of Fields in a Row

To get the sum of fields in a row

  1. In Jotform Tables, add or insert a new column. See How to Add and Organize Columns for more information.
An Add Column button in Jotform Tables
  1. In the dialog, go to Formula at the top, then select Advanced Formula.
An Advanced Formula option in a Jotform Tables Add a New Column dialog
  1. Enter your desired column name.
A Column Name field in a Jotform Tables Advanced Formula dialog
  1. In the editor, create a formula to get the sum of fields using the addition operator (e.g., {Column 1}+{Column 2}+{Column 3}). See Using Advanced Formula to learn more.
  2. Select Create Column at the bottom when finished.
A Create Column button in a Jotform Tables Advanced Formula dialog

You can now view the sum of fields for each row.

Sum of fields for each row in Jotform Tables
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: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

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

Comments:

  • Daksha Saini - Profile picture
  • Marjorie Quetua - Profile picture
  • mike - Profile picture
  • Luis Warren - Profile picture
  • Vivienne van Beusekom - Profile picture