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. Height must be greater than zero. If not given the height of specified base cell range is used. |
| Width (optional) | 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
If height and width define a cell: Value of cell If height and width define a cell range: #VALUE
Examples
| Formula | Result | Comment |
|---|---|---|
| 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. |
