Getting an average between a range of two numbers as indicated by specific cell values

Hello,

I am trying to find the average of a set of numbers when they fall inbetween two values.

for ex. I have 75, 80, 90, 98, 110, 115, and 115. I take the average of those numbers (98) and add and subtact 15 (83 and 113) to set a range for identifying outliers. I want to create another formula to find the average of the orginal data set but excluding the numbers in the data set that fall outside of the specified range. I've tried the =AVERAGEIFS(A1:A7,A1:A7,"<=113",A1:A7,">=83") which worked, but when I enter in the cell name for the values it does not work. Iw ant to creat this formula so it will allow for future averages with different data. Any idea's? I hope that made sense...

Hi chackett,

Try this formula... =AVERAGEIFS($A$1:$A$7,$A$1:$A$7,"<="&C3,$A$1:$A$7,">="&C2)

fantastic! thank you!