i think you need to do it as an array formula
=SUM(INT(A1:A2))
when you're done typing your formula instead of pressing enter press
ctrl-shift-enter. it'll add some curly brackets
{=SUM(INT(A1:A2))}


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=563796