deepcalc
DocsOFFSET

OFFSET

View as markdown/docs/functions/offset.md Ask Claude about this pageOpens Claude with this page's address

Returns reference offset from starting point.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Reference

Examples

=OFFSET(A1, 1, 1)
A
1 10
Result 0
=SUM(OFFSET(A1, 0, 0, 3, 1))
Result, over the same cells 10

Syntax

OFFSET(reference, rows, cols, [height], [width])
reference
range required
rows
number required
cols
number required
height
number optional
width
number optional
ADDRESSReturns a cell address as text from row and column numbers. AREASReturns the number of areas in a reference. HLOOKUPSearches first row and returns matching value. HYPERLINKThe text a link displays: clickability is the renderer's. INDEXReturns value at row and column in range. INDIRECTReturns reference specified by text string.