AVG cells with cell references that contain formulas and numbers

Lisa Wills

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!

2020-12-30_14-01-05.png

Paul Newcome

Happy to help. 👍️

Paul Newcome

Have you tried using an AVG function? If so, what result are you getting?

Lisa Wills

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)

Paul Newcome

Are you putting it in a column that is being used by the dependencies?

Lisa Wills

yes

Paul Newcome

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.

Lisa Wills

Thank you- I appreciate your help!

Paul Newcome

Happy to help. 👍️