Skip to main content

How to sum a column from a default table using another table (cross-referencing)

Learn how to sum a column from a default and display the result in another table

Erin Clazie avatar
Written by Erin Clazie
Updated over 10 months ago

Default tables allow you to continuously add rows when you fill out the form, therefore there isn't a fixed number of rows when the template is created. This doesn't allow you to have a row for totals or sums at the bottom of the same table. The only way to do it is to create a second table for the totals and cross-reference it to the first table.

To start, navigate your cursor to the left tab and choose the 'Default table' under 'Table'. Input your data.

Next, add a 'Prefilled' table under that and set one cell as your display cell.

Use the formula SUM() to your display cell:

=SUM(Source_Table!Column:Column)

For example:

Given that

  • Table1 is the Source_Table

  • A is the Column

  • Table2 cell B1 is your display cell

Use the formula to Table 2 Cell B1,

=SUM(Table1!A:A)

Did this answer your question?