logo ASAP Utilities
HomeExtra features for ExcelInfo & ListAnalyze Selected Cells: Count, Sum, and More...

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

Analyze Selected Cells: Count, Sum, and More...

ASAP Utilities  › Info & List  ›  1. Analyze Selected Cells: Count, Sum, and More...

This tool analyzes your selected range and gives an overview of key values. It provides the following information:
  • Total number of selected cells
  • Number of numeric cells
  • Number of text cells
  • Number of blank cells
  • Sum of numeric values
  • Average
  • Minimum value
  • Maximum value
  • Number of duplicate values (appear more than once)
  • Number of unique values
  • Number of values that appear only once You can optionally create a new workbook with these results. Note:
  • The tool is case-sensitive. For example, "Excel" and "EXCEL" are considered different values.
  • If your selection includes formulas, the tool compares the calculated values, not the formulas themselves. For instance, if one cell displays the number 12 and another cell contains the formula =3*4 resulting in 12, they are considered duplicates.
  • Values in hidden rows (such as in a filtered list) and hidden columns are skipped.

    Screenshots

    Example screenshot: 1
    1, Info & List  ›  1 Analyze Selected Cells: Count, Sum, and More...
    Example screenshot: 2
    2, Info & List  ›  1 Analyze Selected Cells: Count, Sum, and More...
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Info & List  ›  1 Analyze Selected Cells: Count, Sum, and More...
    Additional keywords for this tool:
    count values in selection, sum selected cells, analyze Excel selection, calculate selected range, Excel duplicates count, unique values in selection, Excel quick stats, average selected cells, Excel cell statistics, count text and numbers in range
    Trustpilot
    Download  



    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.