RANGEREF(N1, N2, N3, N4)

 

Description

This function 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.

 

N4

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).