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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!