COUNTIF Function

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.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel