AVG cells with cell references that contain formulas and numbers
Hello- I am trying to avg a group of cells that reference formulas in other sheets and some that only have numbers entered manually. Any advice on what I should do? see screen shot- thank you!
Best Answer
-
Happy to help. 👍️
Answers
-
Have you tried using an AVG function? If so, what result are you getting?
-
Hi Paul- yes and it doesn't give me a result or error message- It just shows this as the formula: =AVG([%Complete]2:[%Complete]11)
-
Are you putting it in a column that is being used by the dependencies?
-
-
There's the problem. Dependency columns do not allow formulas. There should be a built in "rollup" function if the rows you are trying to average are child rows. Otherwise you will need to move it elsewhere in the sheet.
-
Thank you- I appreciate your help!
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!
