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