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, cell reference, or text that defines which cells will be counted. For example, criteria can be expressed as 32, "32", ">32", "apples", or B4.
Remarks
- You can use the wildcard characters, question mark (?) and asterisk (*), in criteria. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
- Microsoft Excel provides additional functions that can be used to analyze your data based on a condition.
- 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.
- To count cells that are empty or not empty, use the COUNTA and COUNTBLANK functions.
Example 1: Common COUNTIF formulas
The example may be easier to understand if you copy it to a blank worksheet.
|
|
Example 2: COUNTIF formulas using wildcard characters and handling blank values
The example may be easier to understand if you copy it to a blank worksheet.
|
|
NOTE To view the number as a percentage, select the cell and click Cells on theFormat menu. Click the Number tab, and then click Percentage in the Categorybox.