Sign in to join the conversation:
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!
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
Hello! I am attempting to create a gift card inventory log and a transaction log. I created a master sheet to house the general inventory. I also created a transaction log. My goal is for them to talk to each. The master sheet will house all of the gift card information like, the serial numbers, description/store, value,…
I want to lookup a specific start date based on 2 criteria: (1) Workset; (2) Week # in the main sheet. I have a separate sheet that contains the dates I am pulling in. I tried using INDEX(COLLECT and I can't seem to get it to work. Data Set: Workset Week # A, B, C, D 1-12 Example: If you have Workset A and Week # 5 the…
Hi How do i set created Date column to only show entries from line 24 downwards?
