Children Formula

Children Formula

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)

Tagged:

Comments

Sign In or Register to comment.