This works for me
=SUMPRODUCT(--(A1:A100=300),--(A1:A100<=10000),A1:A100)/SUMPRODUCT(--(A1:A100=300),--(A1:A100<=10000))

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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