Excel COUNT vs Count Numbers: What’s the Difference?

How-to basics · Updated November 19, 2026

In Excel, COUNT counts cells containing numbers, while the ribbon command called Count Numbers inserts that same function. The status bar’s Count is different: it counts non-empty selected cells, including text, while Numerical Count counts selected numeric cells.

Why Excel has both Count and Count Numbers

The wording is confusing because Excel uses “count” for more than one task. In a formula, COUNT is a worksheet function that returns how many numeric values are in its arguments. The ribbon’s Count Numbers command is a shortcut for creating a COUNT formula. Meanwhile, the Count item on the status bar is a quick summary of the selection, not a formula inserted into a cell.

There is no Excel worksheet function named COUNTNUMBERS. If you want a reusable calculation in a cell, use COUNT for numeric values or choose a different counting function if you mean non-empty cells, blanks, or values matching a condition. If you only need a quick check while selecting data, the status bar may be enough.

What the COUNT function includes

COUNT counts numeric values, including ordinary numbers and dates or times stored as numbers. Excel stores dates and times as serial numbers, so they qualify even if the cells display calendar dates or clock times. A formula whose result is numeric also contributes to the count.

For example, assume A2:A8 contains the number 12, text that looks like “12,” a truly empty cell, a date, a formula that displays an empty string, the logical value TRUE, and an error value. With those entries in A2:A8, =COUNT(A2:A8) returns 2: the number 12 and the date. The text-formatted 12, blank, empty-string result, TRUE, and error are not counted when they are in the referenced range.

COUNT can also take values directly in its argument list, and some values can behave differently there than they do inside a referenced range. For instance, Excel can interpret a numeric text value supplied directly as an argument as a number. For predictable results in a worksheet, judge the function by the values in the referenced cells rather than assuming text that looks numeric will count.

Count Numbers and the status bar are not the same thing

To put a COUNT formula in a worksheet, select a cell where you want the answer, then use the Count Numbers option from the AutoSum dropdown on the ribbon. Excel proposes a range, which you can adjust before confirming. The resulting formula is a normal COUNT formula and updates when its referenced values change. The precise ribbon placement can vary with the window size and ribbon layout.

The status bar works on the cells you currently select. Its Count summary includes non-empty cells whether they contain numbers, text, logical values, errors, or formulas. Numerical Count reports only the numeric entries. To show or hide summaries, right-click the status bar and choose the indicators you want. These summaries are temporary readouts; they do not write a result into a worksheet cell.

This distinction explains a common surprise: selecting a column with names and numbers can show a larger Count than Numerical Count. The first is answering “How many selected cells contain something?” The second is answering “How many selected cells contain numbers?” If you need a total that remains visible and can be used by other formulas, enter a worksheet function instead.

A practical example with COUNT and COUNTA

Suppose a survey response list is in B2:B8. It contains four numeric ratings, two written responses, and one empty cell. With responses in B2:B8, =COUNT(B2:B8) returns 4 because it counts the numeric ratings only. With the same layout, =COUNTA(B2:B8) returns 6 because it counts every non-empty cell, including the written responses.

COUNTA is often the function people meant when they say “count the entries.” It does not mean “count numbers”; it means count cells that are not empty. It also counts cells containing formulas, even if a formula displays an empty string. So the apparent contents on screen do not always tell you whether COUNTA will count a cell: a formula can be present even when its displayed result looks blank.

Here are useful choices for typical requests:

  • Count numeric values, including dates: use COUNT.
  • Count cells containing something, including text: use COUNTA.
  • Count cells that are genuinely empty: use COUNTBLANK.
  • Count values that meet a rule, such as ratings of 5: use COUNTIF.

For example, if the ratings are in B2:B8, =COUNTIF(B2:B8,5) counts cells whose value is 5. If there are three such ratings, the result is 3. COUNTIF is useful when a total needs a criterion rather than a simple distinction between numeric and non-empty cells.

Common reasons a number is not counted

If COUNT returns fewer cells than expected, first check whether some apparent numbers are actually stored as text. This often happens after importing data, pasting values from websites, or receiving entries with leading apostrophes. A value displayed as 12 may therefore be text rather than the number 12. In a referenced range, COUNT ignores that text.

To investigate, select a suspect cell and check its alignment, number format, and formula bar. These clues are not definitive on their own, but a green error indicator or a warning menu may offer a conversion to a number. You can also test a small sample by changing the source data carefully or using a helper column. Do not convert a whole column blindly: identifiers such as product codes, account numbers, and postal codes may be intentionally stored as text, even when they contain digits.

Other frequent causes include:

  • Blanks: genuinely empty cells do not add to COUNT.
  • Text and labels: words, and numeric-looking text in a range, are not numeric values for COUNT.
  • Logical values: TRUE and FALSE in referenced cells are not counted by COUNT.
  • Errors: an error in a referenced cell is not counted as a number.
  • Formulas returning empty text: a formula displaying nothing does not add to COUNT, although COUNTA can still count the cell because it contains a formula.

Also confirm that the formula references the intended range. A correct function pointed at the wrong rows can look like a data-type problem. If the formula shows as text in the cell instead of calculating, check whether the cell is formatted as Text or whether an apostrophe was entered before the equals sign.

How to choose the right counting method

Start by describing what one count should represent. If each valid entry must be a number, COUNT is appropriate. If a name, note, or other text entry should count as a response too, use COUNTA. If you are tallying a particular outcome, such as “Approved” or values above a threshold, choose a criteria-based function such as COUNTIF.

It also matters whether the result is a quick glance or part of a report. Use the status bar when you are inspecting a selection and do not need to retain the answer. Use a worksheet formula when the result must remain in the workbook, update as data changes, appear in a dashboard, or feed another calculation. The status bar can be convenient, but it is not a substitute for a formula in a saved report.

Before finalizing a count, consider whether formulas that display empty text should count as completed entries. COUNT ignores them, while COUNTA counts the formula cells. If your definition of “filled in” is based on the displayed result rather than the presence of a formula, that difference can affect totals. Choose the function based on the meaning of an entry in your data, not just on how the cells look.

Quick checks when results disagree

If a formula count and a status-bar count differ, that may be expected: one may count numbers while the other counts all populated cells. Select only the exact data range, then compare Count with Numerical Count if those indicators are enabled. A large gap suggests the selection includes text or other nonnumeric entries, though it can also include formulas and errors.

For a reliable check, inspect representative cells from each type in the range: an ordinary number, a date, a number-looking text value, and any formula that appears blank. Confirm whether each should count under your definition. Then verify that the formula range covers the intended data and does not include headings or totals. These simple checks usually reveal whether the issue is the function, the source data, or the selection.

Frequently Asked Questions

Is Count Numbers the same as the COUNT formula?
Yes. Count Numbers is an AutoSum command that creates a COUNT formula using a proposed range. The formula counts numeric values in its referenced cells.

Does COUNT count dates in Excel?
Yes. Excel stores dates and times as numeric serial values, so COUNT includes them when they are in the referenced range.

Why does Excel Count show more than COUNT?
The status bar’s Count includes non-empty selected cells, such as text and formulas. COUNT returns only the number of numeric values in its arguments, so text entries can make the status-bar total larger.

Does COUNT include numbers stored as text?
Not when they are in a referenced range. A cell that looks like a number but is stored as text is generally ignored by COUNT. Convert it only when it is meant to be a numeric value; digit-only identifiers may need to remain text.

Which function counts all filled cells?
Use COUNTA to count non-empty cells, including text and cells containing formulas. Remember that a formula returning an empty string can still be counted by COUNTA.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.