Hi,

try =sumif(h15:h35,"<1",h15:h35)

Is it help?
Regards from Brazil
Marcelo


"Hapitaron10" escreveu:


I have a list of numbers I want to pick all those that are less then 1
and add them together , I don't know what cartirea to use? i.e. sumif
(h15:h35,????,h15:h35)
thanks


--
Hapitaron10
------------------------------------------------------------------------
Hapitaron10's Profile: http://www.excelforum.com/member.php...o&userid=34835
View this thread: http://www.excelforum.com/showthread...hreadid=546792