next up previous contents index
Next: RANK Up: A. Function Reference Previous: RAND   Contents   Index


RANGEREF

Syntax: RANGEREF(N1, N2, N3, N4)

N1 = the upper left column index of the range
N2 = the upper left row index of the range
N3 = the lower right column index of the range
N4 = the lower right row index of the range

RANGEREF returns a reference to the range described by corner coordinates N1, N2, N3, and N4. Row index must be relative to 1; column index must be relative to 0.

Examples:

SUM(RANGEREF(0, 1, 0, 2)) is equivalent to SUM(A1..A2)

AVG(RANGEREF(1, 1, 25, 10)) is equivalent to AVG(B1..Z10)

Excel function: N/A


next up previous contents index
Next: RANK Up: A. Function Reference Previous: RAND   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003