look up with multiplication and sum

[marksuza]

Hi, could anybody help me? I have a worksheet with expenses i
different currrency, I wanted to transform everything in dollar an
then add then. In column A I have the expense, in column B I have th
currency. Then I have a table on the side with the exchange rates.
Column C currency again and Column D the exchange rate. Is there a wa
to create a formula where I transform all expenses in dollar and the
add them?

Thanks,

Marco

 

[Frank Kabel]

Hi
why not format the cells conatining the values as currency?. And then
simply use SUM on this range

 

[marksuza]

solve it in a more manual fashion. Two formulas. thanks.

Marcos

 

[Frank Stone]

hi,
you say you have the expecences and the exchange rates.
expence * exchange rate = $.
in colume E enter: =A2*D2
then copy down. formate column E to Currency. sum column E