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: