One way

=SUMPRODUCT(--(0&SUBSTITUTE(SUBSTITUTE(A2:A200,"<",""),"","")) )

will work for greater than as well, if you know you only have less than it
can be simplified to

=SUMPRODUCT(--(0&SUBSTITUTE(A2:A200,"<","")))

note that is you have other text entries it will return a value error

--

Regards,

Peo Sjoblom



"KIM" wrote in message
...
Question 1. How do I average a column that contains a mixture of numbers
and
less than entries?
e.g. 12
<1
10
<5

Question 2. Is it possible to include the less than values in the average
calculation (i.e so excel ignores the less than sign and calcualted the
avearge using the number that is next to the less than sign)?

Question 3. Is it possible to include some less than values (e.g. <10) in
the average calculation but ignore say other less than values (e.g. <100)?

Thank you!