Children Formula

03/23/18 Edited 12/09/19

How can a change this formula to use children in a hierarchy instead of the cell references so when I add a row into the hierarchy it returns the correct value without re-setting the range?


=SUMIF([CQA Status]41:[CQA Status]61, "Red", [No. Cols]41:[No. Cols]61)

Popular Tags:


  • Hi,


    what about : "= SUMIF(CHILDREN([CQA Status]), "Red", CHILDREN([No. Cols])") "


    Hope this helps!


    Best Regards,


    Paul BUREAU

Sign In or Register to comment.