Kornilios Ampatzis/ May 3, 2019/ Functions/ 0 comments

It returns the number of cells of a given cell range that meet a specific criterion.

The syntax of the function is the following:

COUNTIF(range, criterion)

range: The cells or range of cells we want to count.
criterion: It is the criterion that defines which cells of the range should be included in the count.

The function is case insensitive.

You can use the wildcard characters, question mark (?) and asterisk (*), in criteria. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.

Click on the button to practice using this function, with the help of our Online Assessment Tool:


Here is an example of how to use the COUNTIF function:

Navigate to the cell A13 and use the appropriate function to Count how many products are charged with a final price greater than 250.00€

Share this Post

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>