Average with criteria
Hi
I need some help regarding making an average.
There is multiple rows with the text "Mekanisk" in it at "System" column, and a corresponding "%" at the "Fullført" colum.
How do I make an average of all these uniqe % values?
Thank's! :)
Best Answer
-
Hi @TorAtle Myrmel,
If you're after an average for all the %ages in "Fullført" against rows containing "Mekanisk" in "System" then you would use the following formula:
=AVERAGEIF([System]:[System], CONTAINS("Mekanisk", @cell), [Fullført]:[Fullført])
Example:
Hope this helps, but if you've any questions or comments then just post! 😊
Answers
-
Hi @TorAtle Myrmel,
If you're after an average for all the %ages in "Fullført" against rows containing "Mekanisk" in "System" then you would use the following formula:
=AVERAGEIF([System]:[System], CONTAINS("Mekanisk", @cell), [Fullført]:[Fullført])
Example:
Hope this helps, but if you've any questions or comments then just post! 😊
-
Thank you!
-
No problem, happy to have helped!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 141 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!