Microsoft Office Tutorials and References

In Depth Information

**Using Numbers with OFFSET to Describe a Range**

44. The starting column is in cell I2. Column 8 is seven columns to the

right of A1. Therefore, you now use =OFFSET(A1,I1-1,I2-1

=OFFSET(A1,I1-1,I2-1.

55. The structure of the worksheet allows for up to five entries per

month, arranged down a row. Thus, heightis 5 and widthis 1. Use the

following formula to describe the possible range for the month:

=OFFSET(A1,I1-1,I2-1,5,1)

=OFFSET(A1,I1-1,I2-1,5,1). This is good enough to use for MIN, MAX,

SUM, and so on.

66. To chart the data, figure out the exact height. Use the

=COUNT(OFFSET(A1,I1-1,I2-1,5,1))

=COUNT(OFFSET(A1,I1-1,I2-1,5,1)) formula in cell I3 to count the

number of entries for the month.

77. Use the formula =OFFSET(A1,I1-1,I2-1,I3,1)

=OFFSET(A1,I1-1,I2-1,I3,1) to describe the exact

month. Add additional formulas in I4:I6 to figure out the minimum, max-

imum, and sum of those cells.

Even with a poorly designed database spreadsheet, various

combinations of

Figure 12.38.

Figure 12.38.
Even with a poorly designed database spreadsheet, various

combinations of OFFSET

OFFSET can locate and total cells for a specific month.

can locate and total cells for a specific month.