These docs are for v1.0. Click to read the latest docs for v1.2.

COUNTDEEP

Recursively counts the numbers of elements in the specified array.

Syntax

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

Arguments

ArgumentTypeDescription
valueArray or AnyAny 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).