During the period 23/12 to 6/1, we will have slightly longer response times than usual. Merry Christmas and a Happy New Year! 🎄✨

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.