Running into problems trying to use OR logic inside AVERAGEIFS? You’re not alone, and Excel won’t tell you why it’s wrong. It just generates #DIV/0!
In this video, I walk you through exactly why AVERAGEIFS can’t handle OR criteria, why the “average of averages” gives a believable but incorrect result, and the formula you should use instead.
Download a copy of the file(s) used in this video: https://share.zight.com/NQuGeZJo