I'm trying to figure out the formula for an average of some numbers without the low and high numbers to be factored in the average. ie. I have 7 numbers. I want the high and low taken out, and have the average of the middle 5 taken. Can someone supply me with a formula to do this if it's possible? I'm pretty much a formula noob, so, any help would be great.

Find the sum of the range Find the largest Find the smallest Find the count Subtract the largest and the smallest from the sum Divide the above result by count - 2 (@sum(range)-(@max(range)+@min(range)))/(@count(range)-2)

Thanks for your help, but I'm still, unfortunately, confused. I don't understand why you have "@" symbols inserted in there. When I insert my "range" (E3:K3) into your formula, I'm not getting the desired result. This is what I have so far, and I think I'm confusing myself even more. =SUM(E3:K3)-MAX(E3:K3)+MIN(E3:K3)/COUNT(E3:K3) For some reason, I'm not sure how that "-2" fits in properly. Any further assistance is appreciated.

Sorry about the "@", I don't have the EXCEL on this machine, that's for Lotus 123. You subtract 2 to exclude the high and the low. If you always have 7 items then replace count(e3.k3)-2 with 5