Description of formula:
Returns the number of elements in the array or cell range, passed as a parameter. You can also specify several parameters as arrays, cell ranges or single values – then formula returns the total number of elements from all parameters.
Returns the number of elements in the array or cell range, passed as a parameter. You can also specify several parameters as arrays, cell ranges or single values – then formula returns the total number of elements from all parameters.
Syntax:
count(values, …)
count(values, …)
Parameters:
values
(type: any) (multiple parameter) Values to count
Returned type:
Number
Examples:
=count(A1:A20)
=count(section1.A)
=count(A2:B5, C4:C10)
=count(1,12,34,23)
=count(section1.B, section2.A, section3.C)
=count(A1:A20)
=count(section1.A)
=count(A2:B5, C4:C10)
=count(1,12,34,23)
=count(section1.B, section2.A, section3.C)
Remarks:
Elements in a single range or array must be of the same type, but you can specify several arrays of different types as formula parameters.
Elements in a single range or array must be of the same type, but you can specify several arrays of different types as formula parameters.
0 Comments