Microsoft Office Tutorials and References
In Depth Information
Total Cells with AutoSum
chapter 11
Working with Formulas and Functions
Excel displays the AutoSum result
in the cell.
Total Cells without Applying a
1 Click a group of cells whose
values you want to total.
To sum noncontiguous cells, press and hold
while clicking the cells.
Excel adds the contents of the
cells, displaying the sum in the
status bar along the bottom of the
program window.
Excel also counts the number of
cells you have selected.
Excel also displays an average of
the values in the selected cells.
Can I select a
different range of
cells to sum?
AutoSum takes its best
guess when determining
which cells to total. If it
guesses wrong, simply
click the cells you want
to add together before
Can I apply AutoSum to
both rows and columns at
the same time?
Yes. Simply select both the
row and column of data that
you want to sum, along with a
blank row and column to hold
the results. When you apply
the AutoSum function, Excel
sums the row and column and displays the results in
the blank row and column.
or clicking Enter (
Search JabSto ::

Custom Search