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 ItemTransaction TotalItem NumberSold Date
1T-Shirt1,170.00C00102/12/19
2Pants1,491.00C00202/15/19
3Jacket812.00C00302/20/19

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

FormulaDescriptionResult
=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
Was this article helpful?
YesNo