Problem: Your manager calls on the telephone and asks for the total sales of a particular product. You need to quickly find a total. Is there a faster way than entering a formula?
Strategy: The QuickSum indicator in the status bar will show the total of the highlighted cells. With your manager on the phone, highlight the numbers in question, as shown in Fig. 240.
Note: Click any image below to see a larger view of that figure.
Result: As shown in Fig. 241, the QuickSum indicator in the status bar at the bottom of the screen will show that the total of those three cells is 691.
Additional Information: It is possible that you have turned off the status bar. If the status bar is not visible at the bottom of your screen after selecting a range of numeric cells, select View – Status Bar from the menu, as shown in Fig. 242.
In Excel 2007 and 2010, you can customize what appears on the status bar by right clicking the bar and selecting various options.
Gotcha: If one of the values that you select is text, the status bar will show the total of just the numeric entries, as shown in Fig. 243.
However, as shown in Fig. 244, if one of the highlighted cells is an error such as #N/A, then the status bar total will not appear.
Summary: The QuickSum feature in the status bar will show the total of selected cells.
Commands Discussed: View – Status Bar