Easy Explanation Notes with Examples

OFFSET Function in Excel

The OFFSET function returns a cell or range of cells from specified rows and columns of a selected cell or range of cells.

1РThe OFFSET function below returns the cell that is 5th in the row below and 2 columns right to the reference cell i.e. B3.

Result:

Note that the function returns the single cell because both [height] and [width] are selected as 1.

Using OFFSET function within the SUM function

2– To find out sum of the range, the SUM function along with the OFFSET function will be used.

Result:

Using the OFFSET function to make a dynamic named range




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved