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