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

With the AVERAGE functions, either AVERAGE () or MEDIAN (), we have very quickly a problem when our data contains errors, for example zero values or the classic #DIV/0! error. We have to be smart to achieve the desired calculation.

One solution is to use the following formula:


Where I2: I297 is the list of data to be calculated.

But also think about removing errors and zeros beforehand with this tip:

How to remove #DIV/0! and zero values in Excel?


Leave a Reply

Notify of