Prefilled tables allow you to have a fixed number of row which makes it easy to total the sum of a column. You can sum a column by manually adding each cell or by using the SUM formula to calculate a range.
Steps to sum a column
Navigate to the cell where you want the total to appear.
Make sure it's a formula field type.
Enter the cells that you need to add. Each table cell is labeled using a column letter and a row number, such as
A1,A2, etc.Calculate the column total in two ways:
Option 1: Add the cells directly. In the bottom of the prefilled table for example if it's A5, you add the following formula.
=A1+A2+A3+A4
Option 2: If you’re totaling a sequence of cells, use the SUM formula. Make sure to include in the formula the start of the range and the end of the range. In A5 you enter:
=SUM(A1:A4)
Where A1 = the first cell in the range, A4 = the last cell in the range.
All cells between A1 and A4 will automatically be included in the total.
TIP:
Avoid referencing the total cell in your own formula. For example, if your total is in A5, and you include A5 in the formula, the system will show an orange Circular dependency error because the formula is referring back to itself.
Make sure to specify the last row number in your range.
Using an open range like: =A:A on a prefilled table will also result in a circular dependency error, since it tries to include the total cell in the calculation.
Video walkthrough of adding a sum formula: