Skip to main content
Version: Streamsheets 3.0

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

NameTypeDescription
RangeRangeA cell or cell range which defines the base of returned cell range.
RowOffsetNumberRow offset from top left position of Range, might be positive or negative.
ColumnOffsetNumberColumn offset from top left position of Range, might be positive or negative.
Height (optional)NumberNumber of rows for result range. Height must be greater than zero. If not given the height of specified base cell range is used.
Width (optional)NumberNumber of columns for result range. Width must be greater than zero. If not given the width of specified base cell range is used.

Return

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

Examples

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