See all Microsoft Excel tips
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.
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.
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
See all Microsoft Excel tips
