COUNTIF function

The Klipfolio COUNTIF function tests each value in a condition, counts the true results, and returns the count as a single value.

The syntax for the COUNTIF function is:

COUNTIF( condition )

COUNTIF example

Let's look at a COUNTIF function example.




1 Apples 10
2 Oranges 12
3 Pears  
4 Peaches 15
5 Bananas 5

The following example is based on the above text from an Excel spreadsheet:

COUNTIF ( A:A = "Peaches" ) returns 1

Related links: