# Count cells with content in Excel – three formulas that help

In Excel, if you want to change the **Count cells with content**? Then read in this tip, how it works.

## Excel: Count cells with content

The formula for determining the filled cells is ANZAHL2. How to apply the formula.

- Click in an empty cell where you want the number of filled cells to appear.
- Tap
*=NUMBER2(from:to)*a. - Instead of
*from:to*enter the cell range, for example*=NUMBER2(A1:B5)* - Press
*[Return]*. Then the number of filled cells appears.

Read here how to count empty cells in Excel.

Use COUNT2 to count cells that contain digits or text.

## Determine number of cells with numbers

To count the cells that contain numbers, use the formula in the example above

*=NUMBER(A1:B5)*

## Count cells with text

If you only want to determine the number of cells with text, use the formula above

*=COUNTWHEN(A1:A5; “*”)*

Advertising

## Where to count cells with content

- You can display in a questionnaire how many cells are already filled with answers.
- In conjunction with counting empty cells, you can build a nice progress indicator for tables that someone else needs to fill in.