Driller,

Yes this also works,

Thank you.

driller wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200611/1