Difference between revisions of "Manuals/calci/COUNTIF"
Jump to navigation
Jump to search
| Line 22: | Line 22: | ||
*COUNTA() can be used to count the number of non-empty cells that may be numbers, number representation of a text, error or logic values, dates etc. | *COUNTA() can be used to count the number of non-empty cells that may be numbers, number representation of a text, error or logic values, dates etc. | ||
| − | + | == Examples == | |
| + | Consider the following table which shows the color of object in first column and respective count in the second column. | ||
| + | COUNTIF() can be used to count the number of cells that match a given criteria within a mentioned range of values. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
Revision as of 11:22, 4 November 2013
COUNTIF(r, c)
- Where 'r' is the range of cells.
- 'c' is the criteria in the form of a number, expression, cell reference, or text.
- COUNTIF() function calculates the number of cells that satisfy a given criteria.
Description
COUNTIF(r, c)
For example, COUNTIF(A1:A8,"JOHN") returns the number of cells in the range A1 through A8 that match with the text "JOHN".
- Criteria containing numbers can be expressed as 66, "66","<=66", ">=66", "<>66" etc.
- Criteria with text values can be expressed in quotes as "Red" etc.
- Combination of functions can also be used as COUNTIF(A1:A3,"Red")+COUNTIF(A4:A7,"Orange") etc.
- Special characters such as '*', '?', '~' can be used in the criteria field to match a certain sequence of characters.
- COUNT() can be used to count the number of cells in the given range except logical values, error values and text.
- COUNTA() can be used to count the number of non-empty cells that may be numbers, number representation of a text, error or logic values, dates etc.
Examples
Consider the following table which shows the color of object in first column and respective count in the second column. COUNTIF() can be used to count the number of cells that match a given criteria within a mentioned range of values.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | P | 50 | 2 | |
| Row2 | Q | 65 | 2 | |
| Row3 | R | 90 | ||
| Row4 | P | 151 | ||
| Row5 | ||||
| Row6 |
