There may be times in Excel when users do not want to show a “Sum” or “Average,” but want the knowledge for another use.
Excel provides the “Sum” of data on the status bar. Simply highlight the data you want to “Sum” and the status bar will provide the results. No need to create or show a formula on the spreadsheet.
How about when you are curious about the “Average” for a particular group of numbers? The status bar provides the “Average” formula as well.
Each version of Excel is a little different, so view the steps for the version you have.
Excel 2003 (and earlier):
Highlight the data and the status bar will show the “Sum.” See picture above left for reference.
If you want to change the formula, simply right-click on the “Sum” on the status bar and Excel provides a few options. Click on the option of the calculation you want to see.
If you want to view the “Average,” then click “Average” on the pop-up window.
To turn the formula back to “Sum,” repeat the right-click and select “Sum.”
Highlight the data you want to calculate.
Excel 2007 & 2010 provide as many options as you want to view in the status bar. In the 2003 example above, notice I told you to see the “Sum” again, you had to right-click and repeat your steps.
In Excel 2007 & 2010, Excel shows the “Average,” “Count,” and “Sum” as a default.
Right-click and un-check or check the calculations you want to view. Each item that is “checked” will appear on the status bar. At one glance, you can view the “Average,” “Count,” “Minimum,” and “Maximum.”
It’s that simple.