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

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

Regards,
Ryan--

--
RyGuy


"Irfan" wrote:

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

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.

"ryguy7272" wrote:

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

Regards,
Ryan--

--
RyGuy


"Irfan" wrote:

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

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

"Irfan" wrote in message
...
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.

"ryguy7272" wrote:

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

Regards,
Ryan--

--
RyGuy


"Irfan" wrote:

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

Obviously they are numbers fomatted with different currency symbols.

[ and sorry for the incovenience]

"David Biddulph" wrote:

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

"Irfan" wrote in message
...
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.

"ryguy7272" wrote:

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

Regards,
Ryan--

--
RyGuy


"Irfan" wrote:

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