COUNT function is used to get the number of entries in a number field that is in a range or array of numbers.
Purpose : Count numbers
Return value : Count of numeric values
Syntax
=COUNT (value1, [value2], ...)
Arguments
value1 - An item, cell reference, or range.
value2 - [optional] An item, cell reference, or range.
Example:
The COUNT function counts numeric values and ignores text values:
=COUNT(1,2,3) // returns 3
=COUNT(1,"a","b") // returns 1
=COUNT("apple",100,125,150,"orange") // returns 3
Typically, the COUNT function is used on a range. For example, to count numeric values in the range A1:A10:
=COUNT(A1:A100) // count numbers in A1:A10
In the example shown, COUNT is set up to count numbers in the range B5:B15:
=COUNT(B5:B15) // returns 6