Bart,

Array enter using Ctrl-Shift-Enter:

=AVERAGE(IF((A1:A100300)*(A1:A100<10000),A1:A100) )

Change range to match your actual values.

HTH,
Bernie
MS Excel MVP


"Bart Steur" wrote in message ...
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