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

Excel 2016 Example COUNTIF

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.


<< 8. Excel How to calculate days between 2 dates ?

10. Excel How to unhide all ? >>

Reader comments

Add a comment