ARRAYLENGTH
Returns the number of items in an array.
See ARRAY.
The number of items includes items that are themselves part of an array. For example, this array function contains the array "a, b, c", and ARRAYLENGTH returns 8:
=ARRAY(123,789,TRUE,FALSE,"Test","a","b","c",",")
Syntax
=ARRAYLENGHT(array)
Example
This example references an array in cell C8.
=ARRAYLENGTH(C8)
Related topics