# How to Use Excel COUNTIF Function (Examples + Video)

## Excel COUNTIF Function (Example + Video) ### When to use Excel COUNTIF Function

COUNTIF function can be used when you want to count the number of cells that meet a specified criteria.

### What it Returns

It returns a number that represents the number of cells that met a specified criteria in a specified range.

### Syntax

=COUNTIF(range, criteria)

### Input Arguments

• range –  the range of cells which you want to count.
• criteria – the criteria that must be evaluated against the range of cells for a cell to be counted.

• Criteria could be a number, expression, cell reference, text, or a formula.
• Criteria which are text or mathematical/logical symbols (such as =,+,-,/,*) should be in double quotes.
• Wildcard characters can be used in criteria.
• There are three wildcard characters in Excel – the question mark (?), asterisk (*), and tilde (~)
• 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.
• Criteria are case-insensitive (“Hello” and “hello” are treated as same).

## Excel COUNTIF Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Tutorials: FREE EXCEL BOOK