COUNTIF function is used to count the number cells satisfying a specific condition.
Get the count of cells satisfying a specific criteria
A number equivalent to the cells satisfying the condition
range – range of cells to count
criteria – condition to check
Video on COUNTIF Function
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)
New Dynamic Array Functions in Excel