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:

=MEDIAN(IF(ISNA(I2:I297);"";I2:I297))

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?


Related Post

Share

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz