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.
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 are case insensitive.
1. 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.
2. Using Dates as a Criteria: In below example, I have used a date in criteria to find out how many employees have a week off on 4th July.
I have inserted a date directly into the function as a text by using double quotation marks. COUNTIF Function will automatically convert a text into 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 represents a date as per excel’s date system.
To learn more about Excel COUNTIF Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.