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.
In cell C14, the formula is :
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.