Difference between revisions of "Manuals/calci/COUNTIF"
Jump to navigation
Jump to search
| Line 21: | Line 21: | ||
*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. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Lets see an example, | Lets see an example, | ||
Revision as of 11:17, 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.
Lets see an example,
COUNTIF(R,C)
B C
'
P 50
Q 65
R 90
P 151
=COUNTIF(B2:B5,"P") is 2
=COUNTIF(C2:C5,">66") is 2
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | P | 50 | 2 | |
| Row2 | Q | 65 | 2 | |
| Row3 | R | 90 | ||
| Row4 | P | 151 | ||
| Row5 | ||||
| Row6 |
