
Table of Contents
About
COUNTIF function is used to count the number cells satisfying a specific condition.
Function Type
Statistical
Purpose
Get the count of cells satisfying a specific criteria
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 1

Video on COUNTIF Function
Notes
COUNTIF function supports wildcards
To check multiple criteria, COUNTIFS function should be used.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)