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