Function AVERAGE CHILDREN excluding some "childen"

Julie Barbeau

I have a problem with formula "Average Children". In my example below, when there is no cost so % is 0%, it's included in the average of children but should not. In this case, on the third row "3%" should be 23% and in the first row "1%" should be 23%. Is it possible in a formula to say "Average children except if children is 0%"?

Thanks,

Ramzi K

Hi @Julie Barbeau,

Try using this formula instead: =SUM(CHILDREN()) / COUNTIF(CHILDREN(), <>0)

Hope this helps.

Cheers,

Ramzi

Julie Barbeau

Work great! Thanks :)

Ramzi K

Hi @Julie Barbeau,

Try using this formula instead: =SUM(CHILDREN()) / COUNTIF(CHILDREN(), <>0)

Hope this helps.

Cheers,

Ramzi

Julie Barbeau

Work great! Thanks :)