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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!