Microsoft Office Tutorials and References
In Depth Information
Ordering Up Your Results
We’d go on to press Enter, and the numbers in all those cells would be added.
Thus we’re beginning to infer what exactly it is that AutoSum does. It’s programmed to
automatically identify a range of consecutive numbers to be added in the column or row in which you’ve
clicked . And you needn’t click in the cell immediately below the column or immediately to the right of
the row containing the numbers—just somewhere in that column or row. Thus AutoSum will work in the
example shown in Figure 3–7, too:
Figure 3–7. This time it’s a row being added
Starting to get the point? Here we’re adding a row of numbers, even as we’ve spaced the AutoSum cell
two columns away from the last number—and Excel doesn’t mind. And look at the range SUM identified—
it’s included the two empty cells to the left of AutoSum, as the formula itself appears in H16.
In sum (pun intended) and by default, AutoSum will begin to total all consecutive numbers in the
column or row in which it’s been positioned. But what if you see something like Figure 3–8 in cells C18
Figure 3–8. Mind the gap…what about that blank cell?
If you click on cell C25 and turn to AutoSum, the resulting formula will read (Figure 3–9):