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
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!
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!