How the Excel Count function uses the

The Count function is a computed number function. It means to count the number of cells that appear in numbers, and it appears in common functions and statistical functions of Excel functions.

Count function Syntax form: COUNT (value1,value2,...)

Count function Application Considerations:

1, the function will be included in the parameters of the number, text format of the number, the date of the calculation;

2. If the parameter is a cell reference, only statistics are counted; If you want to count logical values, text, or error values in a reference cell, use the function COUNTA;

Count Function Example:

Sample Table	A
1	10
2
3	False
4	0
5	2011-1-1

A is the column number in the table above, and the left 1-5 is the line number. Enter the result of the following formula in a cell:

The result of example 1, =count (1,A1:A3) was 2, because 1 was also involved in statistics as a parameter;

Example 2, =count (A1:A5) result is 3, here 0, and time 2011-1-1 will be counted;

The above is an example of the Count function, I hope that the triple-Ehoy to provide these examples of information for everyone to help Oh!

        Note : more Wonderful tutorials please focus on the Triple computer Tutorials section, triple Computer office group: 189034526 Welcome to join