Assuming source data as posted in A2:A7

Paste this in say, B2,
then press CTRL+SHIFT+ENTER to array-enter the formula:
=AVERAGE(SUBSTITUTE(A2:A7,"<","")+0)

Adapt the ranges to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---
"JD" wrote:
How do I average a column of numbers where less than values are calculated as
that number?

2
<2
3
4
<2
5

In the average I want the<2 to = 2. So the answer should be 3

-- JD