SUM

Formula Explanation

Returns the sum of all values in the column up to the current row.

Returns the sum of all values in the data column up to the current row in the table.

Formula Syntax

Enter in the result column: sum(column number)
Enter in the result column: sum(column number:column number)
Enter in the result column: sum(column number..number)

Usage Examples

1. Calculate the sum of column EM2 and write the result in column EM3.

EM3 = sum(EM2)

2. Calculate the sum of each row in columns EN2 and EN3, and write the result in column EN4.

EN4 = sum(EN2:EN3)

You can also write it as:

EN4 = sum(EN2..3)

✉️ Ask Tablize