If you want to round UP to the nearest integer, then:

=ROUNDUP(SUM(CJ1:CP14),0)

Regards,
Paul

"Earl" wrote in message
...
Current formula:
=SUM(CJ:CP14) formatted, as number to 2 places displays 861.74.
Formatted number 0 places displays 862.

Regardless of formatting, other cells using this cell result, use 861.74,
how can I get the other cells to use the rounded up number.

THX