The COUNTIF function in Excel is used to count the number of cells that meet a specific condition. It is widely used for data analysis and helps in filtering and summarizing data.
Syntax of COUNTIF
COUNTIF(range, criteria)- range: The group of cells to evaluate.
- criteria: The condition that determines which cells to count.
Examples of COUNTIF
1. Counting Cells with a Specific Value
To count how many times “Apple” appears in column A:
=COUNTIF(A2:A10, "Apple")2. Counting Cells Greater Than a Number
To count how many values in column B are greater than 50:
=COUNTIF(B2:B10, ">50")3. Counting Cells with a Partial Match
To count cells in column C that contain the word “Excel” anywhere:
=COUNTIF(C2:C10, "*Excel*")COUNTIF Example Table
| Product | Sales |
|---|---|
| Apple | 55 |
| Banana | 30 |
| Apple | 45 |
| Orange | 25 |
| Apple | 60 |
The COUNTIF function is an essential tool for Excel users to filter and count data based on conditions. Learning this function will improve efficiency and data analysis capabilities.