I have a column I want to average. It always starts at C12, but the column length is dependent on the input data file. At the moment, I use a name defined as follows to refer to the column data.

STRAP
=OFFSET('Input Data'!$D$12,0,0,COUNTA('Input Data'!$D:$D)-2,1)

Then of course I just average strap for the data I require. The problem I have is I want to disqualify certain cells with values much greater than the majority before the average is taken. An example I would have is below.

.1
.1
.2
1.2
.1
.1
1.2
.1
.1
.1

I want to throw out the 1.2s and only average the .1s and .2s.
Any ideas?
Thank you.

Try something like this:

=(SUMIF(B2:B10,"<0.25",B2:B10))/COUNTIF(B2:B10,"<0.25")

This sets the upper limit at 0.25. Adjust as needed.