[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

OFFSET

This function returns a reference to a range. The range is a specified number of rows and columns from a cell or range of cells. The function returns a single cell or a range of cells.

Syntax

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

Arguments

This function has these arguments:

Argument

Description

reference

[Required] The location from which to base the offset

rows

[Required] Number of rows to which the upper-left cell refers

cols

[Required] Number of columns to which the upper-left cell refers

height

[Optional] Number of returned rows; if omitted, same as reference

width

[Optional] Number of returned columns; if omitted, same as reference

The cols can be positive (right of the reference) or negative (left). If height or width is omitted, it is the same as the reference.

Remarks

This is a volatile function.

Examples

OFFSET(D3,2,3,1,1)

OFFSET(D3:E5,2,3,1,1)