How to Get the Sum of Fields in Jotform Tables

July 8, 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.
Steps to get the sum of a column in Jotform Tables
  1. Select Sum from the menu.
Steps to get the sum of a column in Jotform Tables

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.

The 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.
Steps to get the sum of a row in Jotform Tables
  1. In the dialog, go to Formula at the top, then select Advanced Formula.
Steps to get the sum of a row in Jotform Tables
  1. Enter your desired column name.
Steps to get the sum of a row in Jotform Tables
  1. In the editor, create a formula to get the sum of fields using the addition operator. For example, {Column 1}+{Column 2}+{Column 3}.... See Using Advanced Formula to learn more.
  2. When finished, select Create Column at the bottom.
Steps to get the sum of a row in Jotform Tables

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

The 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:

  • mike - Profile picture
  • Luis Warren - Profile picture
  • Vivienne van Beusekom - Profile picture