 Formula Engine Reference Guide |
|
Back to Class Index
RANGEREF(N1, N2, N3, N4)
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.
Parameters
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
N5
the lower right row index of the range
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)