Parameter List
Syntax
OFFSET(reference, rows, cols,
[height]
, [width]
)reference
The starting cell or range from which the offset is calculated. Example: A1.
rows
The number of rows to offset from the starting reference. Example: 2.
cols
The number of columns to offset from the starting reference. Example: 3.
[optional] height
The height (in rows) of the reference to return. Optional, defaults to the original reference's height.
[optional] width
The width (in columns) of the reference to return. Optional, defaults to the original reference's width.