One way

=AVERAGE(IF((A1:A20000)*(A1:A2000<500),A1:A2000))

entered with ctrl + shift & enter

--
Regards,

Peo Sjoblom


"Ditandhischeese" wrote in
message ...
If i have a big column of numbers, and i would want to select that column
and
find the averages of all the numbers in that column that are between 0 and
500, how would i type that formula? Thanks!