excuse me Dai,

"Average If (Value between 1 and 100)"

for the sake of the worksheet function forum readers,
here's a classic non-acrobatic response to a clearly titled question.

=(SUMIF(m8:m5000,"<=100",m8:m5000)-SUMIF(m8:m5000,"<1",m8:m5000))/(COUNTIF(m8:m5000,"<=100")-COUNTIF(m8:m5000,"<1"))

happy holiday
mine driller