Microsoft Office Tutorials and References

In Depth Information

**Summing a group of cells without using a formula**

Summing a group of cells without using a formula

Sometimes, such as when you’re entering data into a worksheet

or you’re curious to find out the sum or average of the values

in a few cells, it’s too much work to find a blank cell and write

a formula to calculate the sum or average for the cells. Rather

than make you create a separate formula, Excel counts the

number of cells selected, calculates a running total and average

for the currently selected cells, and displays the results on the

status bar. Finding the sum, average, and count of the values

in the selected cells are the most commonly used operations,

so Excel calculates those values by default. However, you can

choose from several other operations, or you can even tell Excel

not to calculate a running total for any selected cells.

Summarize data in a group of cells

1
Select the cells that you want to summarize to have the summary

appear on the status bar.

1

Find the total, average, or other values of cell

data

1
Right-click the status bar, and choose the summary operations that

you want from the shortcut menu.

1

TIP Active summary operations are checked on the shortcut

menu. Clicking a checked summary operation turns off that

operation.