OFFSET

Lookup & referenceExcel 2007volatile

Return a range a given number of rows/columns from a starting cell.

Syntax

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

How it works

Volatile — recalculates on every change, which slows large sheets. Prefer INDEX for dynamic ranges.

Examples

=SUM(OFFSET(A1, 0, 0, COUNT(A:A), 1))

→ sum of a growing column

Related functions

INDEX INDIRECT

More Lookup & reference functions

ADDRESS AREAS CHOOSE COLUMN COLUMNS FORMULATEXT GETPIVOTDATA HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.