Mama,

I tried your formula but i still get the #DIV/0! error.

Dons seams to be working well though.

Thanks anyway.

Teethless mama wrote:
=AVERAGE(IF((M8:M50001)*(M8:M5000<100),M8:M5000) )

ctrl+shift+enter (not just enter)

Hello,

[quoted text clipped - 19 lines]

Any Help would be appreciated.