Microsoft Office Tutorials and References
In Depth Information
Ordering Up Your Results
Figure 3–10. Drawing a blank: or rather, drawing your range over a blank cell separating two sets of
As an alternative, nothing prevents you from typing the correct expression in the Formula Bar; but
dragging the desired cells may be visually easier to track. Then press Enter, and all the desired cells are
added. (Don’t, by the way, accidentally over-drag into cell C25—because that cell contains the formula
itself, and you can’t incorporate it into its own result. That kind of miscue is called a circular reference
(and Excel will deliver an onscreen error message to you to that effect), whereby the cell adds itself, as it
were—and that causes way too many problems).
Thus we see that the initial range drawn up by AutoSum is merely a friendly suggestion, yours to
accept or reject, and one you can replace with a different range if events warrant.
And along these lines, suppose you wanted to add the numbers in Figure 3–11, deposited in cells
C14:C16 and E14:E16 respectively:
Figure 3–11. Adding multiple ranges
First, we need to decide the cell in which we want our answer to appear. In the interests of
simplicity, let’s choose cell C17. We click AutoSum, and are presented with the range selection seen in
Figure 3–12, of course:
Search JabSto ::

Custom Search