Range operator

Use to reference a range of cells in a calculation.

Syntax

Calculation(first cell..last cell)

Example

Sum(a1001..c1010)

Sums all the cells from a1001 to c1010.

Related Topics