Tip of the Day | Tuesday April 7th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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

Example screenshot: 2

Starting this tool

Click ASAP Utilities › Info & List › 1. Analyze Selected Cells: Count, Sum, and More...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

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

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Yesterday's Tip

Tomorrow's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

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