Combining formulas for child rows

Irene Plant

I have an easy formula to work out the average data entered into my child rows, the formula is as follows: =AVG(CHILDREN()), this gives me the average of all data put into the child rows perfectly. However, if nothing is entered into these child rows the parent row with the formula in it just shows #DIVIDE BY ZERO. I would like this to be blank while the child rows are blank. I can do a formula to say if it is blank then put nothing but I'm not sure how to combine the two? Any help would be very appreicated.

Many thanks, Irene

Atus Bartal

Irene,

 

you can try this: =IF(SUM(CHILDREN()) <> 0, AVG(CHILDREN(), ""))

 

Atus

Atus Bartal

Oh, sorry, a bracket is in a wrong place (but still works somehow)

Correctly: =IF(SUM(CHILDREN()) <> 0, AVG(CHILDREN()), "")

Irene Plant

Thank you so much Atus this works perfectly!!