Counts the number of cells within a range that meet the given criteria.
Syntax
COUNTIF(range,criteria)
Range is the range of cells from which you want to count cells.
Criteria is the criteria in the form of a number, expression, or text that defines which cells will be counted. For example, criteria can be expressed as 32, "32", ">32", "apples".
Remarks
There are additional functions that can be used to analyze your data based on a condition. For example, to calculate a sum based on a string of text or a number within a range, use the SUMIF spreadsheet function. To have a formula return one of two values based on a condition, such as a sales bonus based on a specified sales amount, use the IF spreadsheet function.
Example
The example may be easier to understand if you copy it to a blank spreadsheet.
How?- Create a blank spreadsheet.
- Select the example in the Help topic.
Selecting an example from Help
- Press CTRL+C.
- In the spreadsheet, select cell A1, and press CTRL+V.
- To switch between viewing the formula that returns the result and the result in the cell, select the cell and press F2 and then ENTER, or click Commands and Options on the spreadsheet toolbar, click the Formula tab, and look in the Formula in active cell (active cell) box.
| Data | Data |
|---|---|
| apples | 32 |
| oranges | 54 |
| peaches | 75 |
| apples | 86 |
| Formula | Description (Result) |
| =COUNTIF(A2:A5,"apples") | Number of cells with apples in the first column above (2) |
| =COUNTIF(B2:B5,">55") | Number of cells with a value greater than 55 in the second column above (2) |