Do you mean sum and round in one go?

=CEILING(SUM(A1:A20),500)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"BAHoffman" wrote in message
...
I need to know how to round the sum of a cell up to the nearest 500. Can
anyone help me with this?? I would appreciate it. Thanks.