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:

=AVERAGEIF(I2:I297;"";0;I2:I297)

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


Related Post

Share

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz