CHILDREN Function

Used within another function to reference the child rows of the referenced parent row.
Sample Usage
COUNT(CHILDREN([Task Name]1))
Syntax
CHILDREN(
  • [
    reference
    ]
)
  • reference
    —[optional]
    A cell in a parent row. If no cell is specified, the function references the children of the current cell.
Examples

This example references the following sheet information:

  Clothing Item Transaction Total Item Number Sold Date
1 T-Shirt 1,170.00 C001 02/12/19
2 Pants 1,491.00 C002 02/15/19
3 Jacket 812.00 C003 02/20/19

Given the table above, here are some examples of using CHILDREN in a sheet:

Formula Description Result
=COUNTIF(CHILDREN([Sold Date]1), MONTH(@cell) = 2) Count the total number of sales for a given month (February in this example).  3
=VLOOKUP(MAX(CHILDREN([Transaction Total]1)), [Item Number]2:[Transaction Total]4, 2) Lookup the item number that had the highest transaction value.  C002
=SUMIF(CHILDREN([Sold Date]1), MONTH(@cell) = 2, CHILDREN([Transaction Total]1)) Returns the summed transaction total for sales that occurred during a specified month (February in this example). 3,115