look up with multiplication and sum

M

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
 
F

Frank Kabel

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

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
 
Top