AvgIF(Children)

Teresa · 05/14/19

Is there a way to get an average of selected cells (all the Children of a column) only if they are not blank? I am stuck and trying to automate the functions as much as possible. Thanks a ton in advance!

Andrée Starå · 05/15/19

Hi Teresa,

Try something like this.

=AVG(COLLECT(CHILDREN(Column@row); CHILDREN(Column@row); NOT(ISBLANK(@cell))))

The same version but with the below changes for your and others convenience.

=AVG(COLLECT(CHILDREN(Column@row), CHILDREN(Column@row), NOT(ISBLANK(@cell))))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

AvgIF(Children)

Comments

Help Article Resources

Categories