Finding nearby cells with offsets

Sometimes you want to calculate things based upon cells close by to the cell you are providing a calculation in.

OFFSET() retrieves the values in cells offset from the current location by a certain number of rows and columns. It takes two arguments: the number of rows down to move from the current location, and the number of columns to move right.

You can also specify height and width arguments to return a range of cells, which is often useful in combination with a summary statistic function like SUM(), AVERAGE() or MAX().