HomeExcel Functions ► Excel COUNTIF Function

Examples-For-Excel-COUNTBLANK-Function

What is the use of Excel COUNTIF Function?

Use Excel COUNTIF Function to count the number of cells which meet a given criteria. In simple words, you can specify a value & count the number of cells which have that value from a given range of cells.

Syntax for Excel COUNTIF Function

COUNTIF(range, criteria)

range A range of cells from which you want to count the cells which meet criteria.

criteria A criteria to check to count cells.

More Information on Excel COUNTIF Function

  • You can use a number, text, cell reference or a formula as criteria.
  • You can also use Wildcard Characters in criteria.
  • Criteria other than numbers & formulas need to enclose in double quotation marks.
  • You can also use logical operators in criteria.
  • Criteria is case insensitive.

Examples to understand Excel COUNTIF Function

Using Logical Operators as a Criteria: In below example, I have used “>75” a logical operator to count the number of students who scored more than 75. If you want to use a logical operator you have to put it inside the double quotation marks.

Syntax-For-Excel-COUNTIF-Function

You can use (>, <, = or <>) operator in your criteria.

Using Dates as a Criteria: In below example, I have used a date in criteria to find out how many enployees have weekoff on 4th july.

Use Date Text Criteria In Excel COUNTIF Function

In above example, I have inseted date directly into the function as a text by using double quotation marks. COUNTIF Function will automatically convert a text into a which represent a date.

Use Date Number Crieria In Excel COUNTIF Function

In above example, I have inserted same date function as a number. As your know excel stores a date as a number. you can also insert a number which represent a date as per excel’s date system.

Download Sample File

Download Sample File To Learn Excel COUNTIF Function

More Tips Related With Excel COUNTIF Function

Conclusion

Use Excel COUNTIF Function to count the number of cells which match criteria. Learn more anout how to use Excel COUNTIF Function from here.

Related Function

Countifs

Excel Functions | Excel Formulas