Pin Me

Microsoft Excel: Count, Average, Etc. Without Using A Formula

written by: Mr Excel•edited by: Michele McDonough•updated: 7/6/2011

You don't need to construct a formula to determine certain measures, like an average, in Excel. Read on to learn a quicker way.

  • slide 1 of 3

    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

  • slide 2 of 3


    Fig. 245Fig. 246Fig. 247
  • slide 3 of 3

    References and Additional Resources

    If you're looking for more tips and tutorials, check out 91 Tips for Calculating With Microsoft Excel. This collection of easy-to-follow guides shows how to customize charts and graphs, different ways to make complex spreadsheets easier to update, and even how to play games like Craps in Excel.

    Other Resources:

    Microsoft Excel Official Site,

    Bill Jelen, Microsoft Excel 2010 In Depth, Available from