Hi,

try this and enter as an array with Ctrl+shift+enter

=AVERAGE(IF((A1:A500=1)*(A1:A500<=10),A1:A500,FAL SE))

Mike

"Techhead" wrote:

I need help writing a formula that calculates the average number that
occurs within a range of numbers. For example, I have a column that
contains 500 rows. Each row contains a random number between 1 and
100. I want to only extract numbers that fall between the range of
1-10 and than compute the avg number that occurs between 1-10.

Thanks,
Brian