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:

Comments

  • Hi,

     

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

     

    Hope this helps!

     

    Best Regards,

     

    Paul BUREAU

Sign In or Register to comment.