Google Sheets Function: COUNTIF

The COUNTIF function returns the number of cells meeting a specific criterion.


=COUNTIF(range, criterion)

Usage Example

The COUNTIF function should return here the number of members who succeeded in obtaining a place on the podium:

google sheets function countif

Enter the COUNTIF function:

The formula is therefore:

google sheets function countif podium
If needed, you can copy the Google Sheets document (or view the document) with this example.

If you need to define additional criteria, use the COUNTIFS function.

Tip: it is possible to use wildcard characters with this function.