Help with RYG Balls - Looking for an Average
Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here is my dilemma. I have a sheet that has linked in RYG balls for health from another sheet. There are three sections, with parent child relationships on each section. I would like to calculate an average for the health of each of the three sections to determine the overall health of each. Any suggestions? TIA!