Microsoft Office Tutorials and References
In Depth Information
Ordering Up Your Results
Figure 3–12. Feeling left out: we want to add 4, 5, and 6 too
Now we have a decision to make. Because we want to add both ranges, we could next drag across all
the cells in question, as in Figure 3–13:
Figure 3–13. Kind of a drag: spanning two ranges to be added in one SUM. Note, however, that the
function treats these values as one range for formula purposes: C14:E16
And that’s what you probably would do, after which you’d press Enter and return your answer. But
suppose there were an additional set of numbers in those in-between cells D14:D16—and you don’t
want these incorporated in your answer. If we proceed with the range selection we’ve just named—
C14:E16—the numbers in D14:D16 will be brought along, because they too inhabit the selected range.
So how do we exclude these unwanted cells?
We can do the following:
Click AutoSum, yielding the initial C14:C16 range selection. Then type a comma (don’t add a space)
and drag range E14:E16 (you can also hold down the Ctrl key after selecting the first range, and then
select E14:E16 (Figure 3–14):
Search JabSto ::

Custom Search