=SUM(IF(LEFT(A2:A4)="<",--RIGHT(A2:A4,LEN(A2:A4)-1),A2:A4)) as an array
formula (Control Shift Enter).
--
David Biddulph


"Vijay Dhawan" <Vijay wrote in message
...
Hi,

How can I sum the numbers in a column in Excel where some numbers carry a
"<" sign in front of them (such as <1) and I want to include numbers such
"<1" in calculation as "1".

For Example if numbers are entered as follows

0.5
<1
0.5

I would like to value to be returned as "2" when I apply "sum" function.

Thanks