Excel Offset Function
The OFFSET function returns the value of a cell that is a specified number of columns and rows away from the start cell.
Structure of formula
Examples of Excel OFFSET function
The above example shows a use of the OFFSET function on year to date (YTD) data.
The formula starts at B4, and moves 0 rows down and across 5 rows (as dictated by cell D7) returning the value of 531.
The OFFSET function can be further enhanced by combining with the SUM function.
Normally the SUM function is driven by the SUM(start range: end range) however in this example we have swapped the “end range” with the offset function thereby making it a dynamic function.
Using the formula
Produces the same results as using the OFFSET function on the YTD values OFFSET in the first example.