Hi,

I have a range of cells (100+), which should all have a value of around
3600, so the average should also be around 3600 (minimum should not be lower
then 300, maximum shouldn't be higher than 10000). But sometimes some cells
contain values of -2000000 or +/-2 or +2000000. So when I calculate the
average (using the AVERAGE Function) I get abnormal results.

Is there a function that can automaticly reconize the excessive values and
exclude them from the Average calculation.

Thanks,

Bart