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

Name

Description

Range

A cell or cell range which defines the base of returned cell range.

RowOffset

Row offset from top left position of Range, might be positive or negative.

ColumnOffset

Column offset from top left position of Range, might be positive or negative.

Height

Optional. Number of rows for result range. If not given the height of specified base cell range is used.

Width

Optional. Number of columns for result range. 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

Function

Result

Comment

1. =OFFSET(A2, 2, 1, 1, 1)
2. =SUM(OFFSET(A2, 1, 1, 2, 1))
OFFSET
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.