This is an array formula that must be entered using ctrl+shift+enter
=AVERAGE(IF((H2:H222)*(H2:H22<6),H2:H22))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"TG" wrote in message
...
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.