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)