Heather,

If you want to keep the original currency and convert the sum, just use

=SUM(A1:A100)*the_rate

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Heather" wrote in message
oups.com...
Is there a way to do this so that when you are adding up different
cells, it does not apply the currency converstion to them, or would u
have to do it section by section?