Microsoft Office Tutorials and References

In Depth Information

**Ordering Up Your Results**

=SUM(B6:B15000)

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

through C24?

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):