OFFSET Function in Excel
Learn how to use the OFFSET function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
OFFSET(reference, rows, cols, [height], [width])referenceRequiredThe starting reference cell or range.
rowsRequiredThe number of rows to move up or down.
colsRequiredThe number of columns to move left or right.
heightOptionalOptional height of the returned range.
widthOptionalOptional width of the returned range.
Examples
=OFFSET(A1, 1, 2)Returns a reference shifted from A1 by one row and two columns.
=SUM(OFFSET(B10, -4, 0, 5, 1))Sums a five-row vertical range ending at B10 for rolling-window calculations.
Common mistakes
Check the argument order, data types, and references used in OFFSET.
Review whether ranges, blank cells, error values, or dynamic results are affecting the formula.
Validate the formula on a few sample rows before scaling it across the workbook.
Related functions
Need a variant of this formula?
Describe your workbook structure and ExcelGPT can generate a version tailored to your real columns, ranges, and edge cases.