Average of only particular selected cells

I'm trying to calculate the average of multiple parent cells in a column, not the whole column, but can't find the correct formula to use. (The parent cells are calculating averages based on other criteria.) TIA!
Best Answer
-
Instead of using the addition sign inside the AVG function, use commas.
=AVG([Column 1]10, [Column 1]20, [Column 1]30)
The way you currently have it written, it is going to add up all of the cells and try to average the result, but since there will only be one number, it will divide by 1 and you will end up with just a sum of the cells.
Answers
-
Instead of using the addition sign inside the AVG function, use commas.
=AVG([Column 1]10, [Column 1]20, [Column 1]30)
The way you currently have it written, it is going to add up all of the cells and try to average the result, but since there will only be one number, it will divide by 1 and you will end up with just a sum of the cells.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!