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.
Note: Commissions may be earned from the links above.
This page contains references to products from one or more of our advertisers. We may receive compensation when you click on links to those products. For an explanation of our advertising policy, please visit this page.
How to obtain the average of the last x cells in the Excel software and thus see if there is an evolution with our data compared to other averages, ...