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).
Updated 9 months ago