=(SUMIF(A:A,"0",A:A)-SUMIF(A:A,"500",A:A))/(COUNTIF(A:A,"0")-COUNTIF(A:A,
"500"))

All on one line, watch out for email word-wrap

Vaya con Dios,
Chuck, CABGx3



"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!