AverageIf
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.
|