How to ignore #DIV/0! and zeros in Excel with AVERAGE()

The AVERAGE function has a problem generating a result from a column that presents errors, such as the famous #DIV/0!, or zero values. How can one ignore these cells and get a correct result?

The solution remains in the following formula:


Where I2: I297 is the column with the data you want to compile.


Leave a Reply

Notify of