Easily Get Sums On The Status Bar In Excel 2007

Here is a nifty tip for Excel users! It’s easy to get a sum in Excel using the AutoSum feature. All you need to do is select the cells containing the values you want to sum, click the first blank cell beside a column or row, and click AutoSum.

Easily Get Sums on the Status Bar in Excel 2007

However, if you need to quickly get sums for subsets of numbers, you get them from the Status Bar. This means you can get a sum without doing a thing! You can even get the average, as well as the number of entries. Once you have your values entered into your spreadsheet, simply select the values that you want to get the sum for and view results in the bottom corner of the Status Bar.

Easily Get Sums on the Status Bar in Excel 2007

As you can see from the figure, Excel displays the Average, Count, and Sum for the select values.

Article Written by