I've had MS Excel Exam. At one of its question, it wants average of the numbers on column B with AVERAGEIFS function but remove the zeros. (There are a lot of zero on column B. As far as I understand it wants me to skip zeros by using formulas.) How to do that?
Bookmarks