AverageIF not working

JMT

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!

Sing C

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

JMT

Hello Sing,

Thank you! It works!! 😀

With much appreciation,

JMT

Sing C

Most welcome @JMT. Have a great weekend.