1. Spreadsheet.com Support
  2. Functions
  3. Hierarchy functions

CHILDCELLS

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.

 

Sample Usage

COUNT(CHILDCELLS())

COUNT(CHILDCELLS(A3))

SUM(CHILDCELLS(A3))

 

Syntax

CHILDCELLS(cell)

  • 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.

 

Examples

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.

 

Notes

  • 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.