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

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

THAT DID THE TRICK, THANK YOU

"T. Valko" wrote:

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

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"swell estimator" wrote in
message ...
THAT DID THE TRICK, THANK YOU

"T. Valko" wrote:

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