Use the ROUND formula:

=ROUND(9.4,0) --9
=ROUND(9.5,0) --10
0 stands for 0 decimals

Then sum the values

Hope it helped
Ola Sandström


=ROUNDUP(9.1,0) -- 10
=ROUNDDOWN(9.1,0) -- 9


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390519