|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

Advanced Example: Combining CHILDREFS usages

Begär demo
  • Redigerad

You can include the CHILDREFS function more than once in a formula. This enables you to compound aggregations from different parent sheets all in one formula. 

  • In the above example, the North America sheet is a sibling to the “NII Summary” sheet, containing its own child sheets.
  • To ensure the North America values are captured in the “NII Summary” sheet, we append “(SUM(CHILDREFS('North America'!B10)))” to the existing formula.
    • This tells the formula to also sum cell B10 in each child sheet to “North America”.

Go here for advanced examples of Nesting CHILDREFS Formulas.

0

Kommentarer

2 kommentarer

Datum Röster
  • Blaine Browning

    It states that I'm not authorized to view the "Nesting CHILDREFS Formulas" page.

    0
  • Mike Davis

    Thanks for the heads up, Blaine. I have fixed the issue and you should be able to access now.

    0

Du måste logga in om du vill lämna en kommentar.