How to Use Excel COUNTIF Function (with Examples)
COUNTIF Function is one of the Statistical Functions, to count the number of cells that meet a criterion; for example, to count the number of times a student appears in an attendance list.
The simplest form of COUNTIF is:
=COUNTIF(Where do you want to look?, What do you want to look for?)
The COUNTIF function in Excel is used to count the number of cells.
Syntax:
COUNTIF (range, criteria)
Arguments:
1. range:- Here range refers to the range of the cells for which you want the cell count for a specific condition.
2. criteria:- Here criteria refers to the condition for which you want the cell count.
Return Value:- COUNTIF function in excel returns an integer value of the number of cells which satisfy the given condition.
Excel COUNTIF Function
The COUNTIF function in Excel is used to count the number of cells that match a single condition applied. It can include Dates, Numbers, and Texts. It uses various logical operators like <(Less Than), >(Greater Than), >=(Greater Than or Equal to), <=(Less Than or Equal to), =(Equals to), and <>(NOT) for matching the condition. It also uses some wildcards like * and ? for partial matching.