OFFSET function

OFFSET returns the value of a cell the location of which is offset by a certain number of rows and columns.

Syntax

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

Example

=OFFSET(A1,2,2) returns the value in cell C3 (A1 moved by two rows down and two columns right). If C3 contains the value 100, this function returns the value 100.

=SUM(OFFSET(A1,2,2,5,6)) determines the total of the area that starts in cell C3. This area has a height of five rows and a width of six columns (area=C3:H7).




Trademarks | IBM Connections wiki