21. Excel How to count cells with a specific text ?


To count the cells with a specific text, use the function COUNTIF.

The function COUNTIF returns the number of occurrences of the value given in the 2nd argument in the range of cells given in the 1st argument.

Here is a concrete example:

Excel 2016 Example Count cells with a specific text

In cell B3, the formula is :

=COUNTIF(C7:C26,"Successful")

This formula counts the number of occurrences of the value "Successful" in the cell range C7:C26.


<< 20. Excel How to compare two columns ? How do I fill in one sheet from another ?

22. Excel How to calculate a percentage? >>