can't roundup sum

[swell estimator]

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

 

[T. Valko]

This will round up to the next whole 1:

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

 

[swell estimator]

THAT DID THE TRICK, THANK YOU

This will round up to the next whole 1:

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

 

[T. Valko]

You're welcome. Thanks for the feedback!