COUNTDEEP

Recursively counts the numbers of elements in the specified array.

Syntax

=COUNTDEEP(value1, value2, ..., valueN)

Arguments

Argument	Type	Description
value	Array or Any	Any value to count, which can be an array, reference or a single value.

Examples

=COUNTDEEP(1, 2, 3) → 3
Counts the number of arguments (1, 2, and 3), which is equal to 3.

=COUNTDEEP(ARRAY(4, 5), 6) → 3
Counts the values in the array [4, 5] and 6. Because COUNTDEEP flattens arrays, this is equivalent to counting the number of elements: 3.

=COUNTDEEP(children) → 6
Counts all children on the current shape.

=COUNTDEEP(children."Property 2") → 4
Counts all children's data property values that have a value for "Property 2" (10, 18, 13, 14).