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