Microsoft Excel Functions & Formulas

Use the OFFSET function to sum sales for a

specified period

Figure 9-17 gives an overview of the monthly sales figures from the

previous year. Let’s sum the sales from January to November. To do

so, use the OFFSET function in combination with SUM. OFFSET

returns a reference to a range that is a specific number of rows and

columns from a cell or range of cells.

The syntax is:

OFFSET(reference, rows, cols, height, width)

reference: The reference that is the base for the offset.

rows: The number of rows to which the upper-left cell should

refer.

cols: The number of columns to which the upper-left cell should

refer.

height: The height, in number of rows, that ...