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.
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.