How to Use Excel COUNTIF Function (Examples + Video)

Excel COUNTIF Function (Example + Video)

Excel COUNTIF Function

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.


=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.

Additional Notes

  • 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 – Live Example

Excel COUNTIF Function – Video Tutorial

Related Excel Functions:

You May Also Like the Following Tutorials:

Excel Ebook Subscribe


Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster