Problem: Your manager calls on the telephone and asks for the average price of a particular product. You need to quickly find an average of the prices in Fig. 245. Is there a faster way than entering a formula?
Note: Click any figure for a larger view of that image.
Strategy: The QuickSum feature in the status bar can be customized to show Average, Min, Max, Count, or Count Numbers. Highlight a range of numbers. Look for the QuickSum value in the status bar at the bottom of the window.
As shown in Fig. 246, right-click the QuickSum and a menu pops up allowing you to choose Average, Count, Count Numbers, Max, Min, or Sum. Select Average.
Result: The QuickSum changes to show an average, as shown in Fig. 247. Nice and easy!
Additional Information: Excel will remember the setting of the QuickSum area from session to session. If you change from Sum to Average, it will continue to show averages of the selected cells until you change this back to a Sum. Count will count all non-blank cells in the selection. Count Nums will only count cells that contain numeric or date values.
Summary: You can quickly find the average, count, min, or max of a range by using the right-click menu to customize the QuickSum information in the status bar.
Commands Discussed: Status Bar – QuickSum
See all Microsoft Excel tips