thank you vary much this works just fine , One more quick oni if I need
a range should I replace if i.e. isumif( a1:a10, "=1 and <3, a1:a10)
Thanks


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