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