Difference between revisions of "Manuals/calci/COUNT"
Jump to navigation
Jump to search
| Line 99: | Line 99: | ||
{| class="MsoNormalTable" | {| class="MsoNormalTable" | ||
| valign="top" | | | valign="top" | | ||
| − | + | =COUNT(A1:A5) | |
| valign="top" | | | valign="top" | | ||
| − | + | Counts the number of cells that contain numbers in the cells A1 to A5. ''Gives result 3 | |
|- | |- | ||
| valign="top" | | | valign="top" | | ||
| − | + | COUNT(C5:C7) | |
| valign="top" | | | valign="top" | | ||
<font size="3"><font face="Times New Roman">Counts the number of cells that contain numbers in the last 4 rows of the list (3)</font></font> | <font size="3"><font face="Times New Roman">Counts the number of cells that contain numbers in the last 4 rows of the list (3)</font></font> | ||
Revision as of 15:32, 1 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.
Examples
For better understanding of the COUNT() function, consider the below table which contains different types of data in various columns.
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Sales | 4 | ||
| Row2 | 23/8/2009 | 3 | ||
| Row3 | 0 | |||
| Row4 | 22 | |||
| Row5 | 52.69 | 0 | ||
| Row6 | 1 | |||
| Row7 | #DIV/0! |
|
=COUNT(A1:A5) |
Counts the number of cells that contain numbers in the cells A1 to A5. Gives result 3 |
|
COUNT(C5:C7) |
Counts the number of cells that contain numbers in the last 4 rows of the list (3) |