Table of Contents
About
COUNTIF function is used to count the number cells that satisfy a specific condition.
Function Type
Statistical
Purpose
Counts the number of cells in a range that meet a single condition.
Return value
A number equivalent to the cells satisfying the condition
Syntax
=COUNTIF(range,criteria)
Arguments
range – range of cells to count
criteria – condition to check
Example:
=COUNTIF(B2:B10, ">50")Counts how many values in B2 to B10 are greater than 50.
Use Case Example: To count how many times “Completed” appears in column C:
=COUNTIF(C2:C100, "Completed")Note:
Criteria can use comparison operators (>, <, =) or text. You can also use wildcards: * for multiple characters, ? for a single character.
Video on COUNTIF Function
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)