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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!