D
driller
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
"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