ARRAYLENGTH

This function returns the number of items in an array.

Syntax

=ARRAYLENGTH(array)

Example

This example references an array in cell C8.

=ARRAYLENGTH(C8)