Skip to main content
Version: Streamsheets 2.4

OFFSET

Returns a cell range that is defined by specified number of rows and columns from an initial range.

Syntax

=OFFSET(Range, RowOffset, ColumnOffset [, Height, Width])

Arguments

NameDescription
RangeA cell or cell range which defines the base of returned cell range.
RowOffsetRow offset from top left position of Range, might be positive or negative.
ColumnOffsetColumn offset from top left position of Range, might be positive or negative.
HeightOptional. Number of rows for result range. Height must be greater than zero. If not given the height of specified base cell range is used.
WidthOptional. Number of columns for result range. Width must be greater than zero. If not given the width of specified base cell range is used.

Return Value

If height and width define a cell: Value of cell
If height and width define a cell range: #VALUE

Example

FunctionResultComment
1. =OFFSET(A2, 2, 1, 1, 1)
2. =SUM(OFFSET(A2, 1, 1, 2, 1))
1. 6
2. 10
1. B4 has an offset of 2 rows and 1 column from A1. The cell value is 6.
2. B3 has an offset of 1 row and 1 column from A1. The SUM of the range defined through height and width is 10.