OFFSET function

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


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


=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