This function is designed for working with data in row hierarchies.
Returns the values of all cells that are descendants of the specified cell. If no cell is specified, the cell the function is called within is used as the reference.
Sample Usage
COUNT(DESCENDANTCELLS())
COUNT(DESCENDANTCELLS(A3))
MAXA(DESCENDANTCELLS(A3))
Syntax
DESCENDANTCELLS(cell)
- cell - [OPTIONAL] The cell to use as a reference for retrieving all descendant cell values. If no cell is provided, this function returns all descendant cell values of the cell it is called from.
Examples
COUNT(DESCENDANTCELLS()) returns the number of descendent cells below the current parent cell.
COUNT(DESCENDANTCELLS(A3)) returns the number of descendent cells below cell A3.
MAXA(DESCENDANTCELLS(A3)) returns the maximum value of all descendent cells below cell A3.
Notes
- DESCENDANTCELLS returns an array of values.
- DESCENDANTCELLS will be recalculated on indent/outdent changes, create row and delete row actions, etc.
- Unlike the CHILDCELLS function, DESCENDANTCELLS returns all descendent cell values of the current cell, not just first-level child cell values.