Hi, I have a set of data in different currencies, how to I convert them into single currency then sum up into a single currency?
I would love to have the figure in xx field by month.
If I do it manually, the xx highlighted in red should be =(C2*I1)+(C5*I2)+(C8*I3), but I would like to have a single formula for all as there would be more names adding in and i would have to add it into the formula manually.
I have tried Sumproduct, Sumif.. but I am stuck. Please help.
CNY 0.1500
HKD 0.1200
IDR 0.0007
Name Cur Jan Feb Mar
Peter CNY 100 20 30
Jane CNY 50 30 20
Jack CNY 100 40 30
Peter HKD 50
Jane HKD 60 50
Jack HKD
Peter IDR 50 20 30
Jane IDR 20 20
Jack IDR 30 10
Jan Feb Mar
Peter USD xx xx xx
Jane USD xx xx xx
Jack USD xx xx xx
Bookmarks