AverageIf
Maybe
=AVERAGE(IF($A$1:$A$152,IF(A1:A15<8,A1:A15)))
Array entered with Ctrl+Shift+Enter
Mike
"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.
|