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. Search JabSto ::

Custom Search