|
<< Click to Display Table of Contents >> COUNTIF (count if condition is true) |
Syntax:
COUNTIF(Range, Criterion)
Description:
This counts those cells in a cell range that fulfill the specified criterion.
Range is the cell range to be evaluated.
Criterion is the condition that the values in Range have to fulfill to be included:
On the one hand, you can simply specify a value here (for example, "42" or "screws"). In this case, all items that correspond to this value are counted.
Tip: To count all non-empty cells, specify "*" as the criterion. For example, COUNTIF(D2:D4, "*") counts all cells in the specified range that are not empty.
Furthermore, you can also use conditions like ">10" or "<=5". All items that match the specified condition are counted here.
Note: Criteria always have to be enclosed within double quotation marks (").
Example:
The cells A1:A5 contain the values 1, 2, 3, 2, 1.
Then the following applies:
COUNTIF(A1:A5, "2") returns 2
COUNTIF(A1:A5, ">=2") returns 3
Tip: A modification of the formula is required if a cell reference is entered for the search criterion instead of a constant. Here's an example:
Cells A1 to A5 contain the above example values. In addition, cell C1 contains the value 2.
You now want to find out how many values in the range A1:A5 are greater than the value in cell C1.
Then the formula is COUNTIF(A1:A5, ">"&C1) and returns 1
See also: