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*

Grey Trout Software

02 March 2003