SUM UP DIFFERENT CURRENCIES

[Irfan]

I have a list in which a column contains amount paid to various suppliers in
various currencies such as Pounds, Dollars and Yen. I want to sum up the
amount in different currencies Like:

Total Dollars Paid
Total Pounds Paid
Total Yen Paid

Please help

 

[ryguy7272]

Use a Pivot Table:
http://peltiertech.com/Excel/Pivots/pivottables.htm

Regards,
Ryan--

 

[Irfan]

Thanx. But i feel u do not understand my question. Here is list

Date Supplier Product Qty Amount
27/01/2008 XYZ ABC 20 £23.00
27/01/2008 OPL Buns 10 £22.00
29/01/2008 OBS Deca 3 $3.00
29/01/2008 OPL Deca 5 $3.00
29/01/2008 OBS Fil 3 $3.00
27/01/2008 XYZ ABC 20 $3.00

What i want to sum up the dollars and pounds separately.

 

[David Biddulph]

So how are your amounts entered? Are they all text strings, or are they
numbers formatted as currency with different symbols, or ...?

[And in future, please supply the relevant information when you ask the
question. It'll save your time, and ours.]

 

[Irfan]

Obviously they are numbers fomatted with different currency symbols.

[ and sorry for the incovenience]

So how are your amounts entered? Are they all text strings, or are they
numbers formatted as currency with different symbols, or ...?

[And in future, please supply the relevant information when you ask the
question. It'll save your time, and ours.]
--
David Biddulph

Thanx. But i feel u do not understand my question. Here is list

Date Supplier Product Qty Amount
27/01/2008 XYZ ABC 20 £23.00
27/01/2008 OPL Buns 10 £22.00
29/01/2008 OBS Deca 3 $3.00
29/01/2008 OPL Deca 5 $3.00
29/01/2008 OBS Fil 3 $3.00
27/01/2008 XYZ ABC 20 $3.00

What i want to sum up the dollars and pounds separately.