# 9. Excel How to count cells with text ?

To count the number of cells with text in a cell range, use the Excel function COUNTIF with:

- as first argument the cell range and
- the wildcard character "*" as the second argument.

NB. Remember that with the COUNTIF function, the wildcard character * corresponds to zero, one or more characters. Cells with number values are not counted with the wildcards * or ?. Cells with errors are also not counted.

## Example

In cell C14, the formula is :

=NB.SI(A1:C11;"*")

*Excel functions for counting the number of cells*

I remind you of the Excel functions for counting the number of cells:

**COUNTA**: determines the number of non-empty cells in one or more cell ranges.

**COUNT**: determines the number of cells containing numbers in one or more cell ranges. I remind you that dates are also considered as numbers in Excel.

**COUNTBLANK**: determines the number of empty cells in a cell range.

**COUNTIF**: determines the number of cells that check a condition.

**COUNTIFS**: determines the number of cells that check conditions.

See the Excel Functions course and the chapter COUNTIF, COUNTIFS, SUMIF and SUMIFS functions.