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
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.
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.
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.
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
Use Excel COUNTIF Function to count the number of cells which match criteria. Learn more anout how to use Excel COUNTIF Function from here.