SUM
Adds all the values in the cell group.
FORMAT: SUM ( reference .. reference )
DEFINITIONS:
- reference: column number or column title, row number or quoted text representing a cell title
EXAMPLE 1:
sum (2,1..4,3)
Returns the sum of all cells between column 2, row 1 and column 4, row 3
EXAMPLE 2:
sum ("cell1".."cell2")
Returns the sum of all cells between cells with titles "cell1" and "cell2"
EXAMPLE 3:
sum (2,1.."column1",4)
Returns the sum of all cells between column 2, row 1 and the column with the title "column1" on row 4
EXAMPLE 4:
sum ($column+1,$row..$column+2,$row+1)
Returns the sum of all cells 1 column right of current cell to 2 columns right, 1 row down
Available for spreadsheet windows version 9 and later.