Skip to main content
All CollectionsSupport GuideDashpivot - WebFormulas Functions
How to sum a column at the bottom of a prefilled table
How to sum a column at the bottom of a prefilled table

Prefilled table: Learn how to use use the sum formula and calculate the total sum of a column

Janmari Tanga-An avatar
Written by Janmari Tanga-An
Updated over 5 months ago

Calculating the total sum of a column in a prefilled table has been made easy with a sum formula.

To start, navigate your cursor to the left tab and drag the 'Prefilled table' under 'Table'. Prefilled tables allow you to have a fixed number of row, thus making it easier to total the sum of a column.

To sum a range of cells, use the formula:

=SUM(Number1:Number2)
  • Where Number1 is the start of the range, and Number2 is the end of the range.

  • Number1, Number2, and the numbers in between will automatically be summed.

For example:

Given that the cells contain these numbers,

A1 = 5

A2 = 10

A3 = 15

A4 = 20

Therefore the formula,

=SUM(A1:A4)

Returns the value, 50.

Did this answer your question?