📆 14-day money-back guarantee | 🔃 Switch courses anytime | 🔒 Secure payment and fast support

Want to get free access to our Excel functions course?

Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.

OFFSET

See more Excel functions
Share

In this lesson we will be taking a look at the OFFSET function, which returns a range of cells given a certain position in relation to a specified cell.
It consists of five arguments: The origin cell, which for us will be C7
 how many rows down
 and how many columns to the right we want to reference
 We then define the height
 and width of the range we want.
We are now referencing the single cell that is 4 rows down, and one column over from cell C7.
Note that setting the location of the range as negative numbers, is the same as going up or to the left.
Having more than one as the height or width only works if we are using the function somehow.
For example, we can put an OFFSET function inside an AVERAGE function
 and set the width and height to two, in order to get the average of the values in these four cells

We have in this lesson shown how to use the OFFSET function.