Hi

one method
=SUMIF(B2:B27,"<="&10,A2:A27)/COUNTIF(B2:B27,"<="&10)

as long as you don't have any negative numbers in B

Cheers
JulieD


"BAM718" wrote in message
...
Column A has a Range of Dollar Values ($0 - $100,000). Column B has a
Range
of numbers from 0 to 100.

I want to return an average of the Dollar Values in column A but only
using
the Dollar Values that have a corresponding number in column B between the
range of 0 to 10.