You can use =sumif()/countif()

=sumif(original!k2:k10,"<"&10) / countif(original!k2:k10,"<"&10)



"Linda (RQ)" wrote:

Hi,

I am using Excel 2003. On my sheet named "Original" in column K I have a
list of numbers they range from .1 to 50 but could go higher. On another
sheet I have this function =AVERAGE(Original!K2:K10) in a cell which give me
the average of these numbers. I would like to make another cell with the
same function but I want to it to only average items in column K that are
less than 10 and ignore any that are 10 or more.

Thanks,
Linda

--

Dave Peterson