OFFSET function


DESCRIPTION:

Returns a reference to a range that is given a number of rows and columns from a given reference.

 

SYNTAX:

=OFFSET( reference, rows, cols, [height], [width] )

 

REQUIRED ARGUMENTS:

reference

The starting point supplied as a cell reference or range.

rows

The number of rows to offset below the starting reference.

cols

The number of columns to offset to the right of the starting reference.

 

OPTIONAL ARGUMENTS:

[height]

The height in rows of the returned reference.

[width]

The width in columns of the returned reference.