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:
- The CHILDREN function in the following examples reference a parent row. More on Rows and Hierarchy.
- Some of these examples use the @cell parameter. More on @cell.
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 |