|
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".
Remark
Microsoft Excel provides 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 worksheet 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 worksheet function. Learn about calculating a value based on a condition.
Examples
Suppose A3:A6 contain "apples", "oranges", "peaches", "apples", respectively:
COUNTIF(A3:A6,"apples") equals 2
Suppose B3:B6 contain 32, 54, 75, 86, respectively:
COUNTIF(B3:B6,">55") equals 2
(c) Microsoft
|