You guys all rock. All these methods work and are exactly what I was after.

Thank you!

"Brad" wrote:

Here is yet a different way
=SUMPRODUCT(--(F6:F152),--(F6:F15<8),F6:F15)/SUMPRODUCT(--(F6:F152),--(F6:F15<8))

If you want to include either 2 or 8 change the inequality to = or <=
respectively.
--
Wag more, bark less


"TG" wrote:

Is there a way to average a range of data?

For example: I have a column with values 1,2,3,4,5...10 and I want to
average those values greater than 2 but less than 8.

I *think* the AverageIfs will work but it is my understanding that this
function is only valid in the most current versions of excel. If so, I would
like to find a function that is more compatible.

Thank you.