Children Formula

Tom Holder

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)

p_bureau

Hi,

 

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

 

Hope this helps!

 

Best Regards,

 

Paul BUREAU