AvgIF(Children)

Teresa

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å

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