AverageIF not working
Hello,
I am trying to average 3 numbers IF the status is "In Progress". I can't seem to get it work properly. The numbers I want to average are Schedule at Risk, Resources -Health and, Scope - Health. I only want those numbers averaged IF the project is active, "In Progress". Below is a screenshot of the data and my formula. Any help would be greatly appreciated.
Thank you!
Answers
-
Hi @JMT,
Unfortunately, the AVERAGEIF formula only works if you have only one criteria to search.
In this instance I would use an IF to decide whether to average the cols:
=IF([Project Status]@row = "In Progress", AVG(<your col range>))
I hope that helps.
Let me know if that achieves your desired result.
Thanks,
Sing
-
Hello Sing,
Thank you! It works!! 😀
With much appreciation,
JMT
-
Most welcome @JMT. Have a great weekend.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!