Difference between revisions of "Manuals/calci/COUNT"
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 4'' as a result. | Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) ''returns 4'' as a result. | ||
| − | COUNT | + | COUNT(A1:A8,7,13) ''returns 6'' as a result. |
* The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted. | * The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted. | ||
| Line 22: | Line 22: | ||
* COUNTIF() can be used to count the number of cells that satisfy the given criteria. | * COUNTIF() can be used to count the number of cells that satisfy the given criteria. | ||
| − | + | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Examples == | == Examples == | ||
| + | |||
For better understanding of the COUNT() function, consider the below table which contains different types of data in various columns. | For better understanding of the COUNT() function, consider the below table which contains different types of data in various columns. | ||
| + | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class="sshl_f" | Sales | | class="sshl_f" | Sales | ||
| class="sshl_f" | 4 | | class="sshl_f" | 4 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="odd" |
| − | |||
| class="sshl_f" | 23/8/2009 | | class="sshl_f" | 23/8/2009 | ||
| class="sshl_f" | 3 | | class="sshl_f" | 3 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="even" |
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_fSelectTD SelectTD " | | | class="sshl_fSelectTD SelectTD " | | ||
| Line 66: | Line 45: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | 0 | | class="sshl_f" | 0 | ||
| − | |- class=" | + | |- class="odd" |
| − | |||
| class="sshl_f" | 22 | | class="sshl_f" | 22 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="even" |
| − | |||
| class="sshl_f" | 52.69 | | class="sshl_f" | 52.69 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| 0 | | 0 | ||
| − | |- class=" | + | |- class="odd" |
| − | |||
| class="sshl_f" | 1 | | class="sshl_f" | 1 | ||
| class="sshl_f " | | | class="sshl_f " | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="even" |
| − | |||
| class="sshl_f " | #NUM! | | class="sshl_f " | #NUM! | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| Line 91: | Line 66: | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|} | |} | ||
| − | + | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="5SpaceContent" class="zcontent" align="left"> | <div id="5SpaceContent" class="zcontent" align="left"> | ||
Revision as of 19:24, 5 November 2013
COUNT(v1, v2...)
- Where v1, v2 ... are the arguments.
- COUNT() returns the number of cells that contain numbers, and also numbers within the list of arguments.
- Arguments can be numbers, dates or text representation of numbers.
- Logical values, text, error values are ignored.
Description
COUNT(v1,v2...)
Consider columns A1 to A8 contain 4 numbers. Then the function COUNT(A1:A8) returns 4 as a result.
COUNT(A1:A8,7,13) returns 6 as a result.
- The arguments may be any kind of data such as numbers, date, text, empty cells etc. but only numbers are counted.
- Any error values, text, empty cells or logical values are not counted.
- COUNTA() can be used to count the number of cells with empty text("") or error values.
- COUNTIF() can be used to count the number of cells that satisfy the given criteria.
Examples
For better understanding of the COUNT() function, consider the below table which contains different types of data in various columns.
| Sales | 4 | ||
| 23/8/2009 | 3 | ||
| 0 | |||
| 22 | |||
| 52.69 | 0 | ||
| 1 | |||
| #NUM! |
|
=COUNT(A1:A5) |
Counts the number of cells that contain numbers in the cells A1 to A5, returns 3 as a result. |
|
=COUNT(A4:A7) |
Counts the number of cells that contain numbers in the cells A4 to A7, returns 3 as a result. |
|
=COUNT(C5:C7) |
Counts the number of cells that contain numbers in the cells C5 to C7, returns 0 as a result. COUNT() ignores the empty cells. |
|
=COUNT((D1:D4),2) |
Counts the number of cells that contain numbers in the cells D1 to D4, returns 2 as a result. |