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.
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.