This will round up to the next whole 1:

=CEILING(SUM(A1:A10),1)

--
Biff
Microsoft Excel MVP


"swell estimator" <swell wrote in
message ...
shouldn't I be able to roundup a sum? The only way I can do it is to
first
convert the sum to a number and roundup the number. That means 2 columns
and
I want only 1 column. I could hide the sum column BUT is that the only
way
to do it?

Excel 2003