Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

4 points

SUM and CURRENCYCONVERT together in one cell?

Hi, I have a row of US$ amounts that I want to add and simultaneously convert into another currency in the Total Column.

I'd appreciate if you experts could let me know if possible, and if so, then how.

Many thanks,

Greg

Posted on Aug 21, 2021 1:13 AM

Best reply

Level 7

26,704 points

Posted on Aug 21, 2021 5:39 AM

SUM them first then convert the result, like shown below:

=CURRENCYCONVERT(SUM(B2:E2),"eur")

View in context

Similar questions