I have a worksheet containing different suppliers list with their products
and their amounts in different currencies (formatted as numbers with
different currencies). as mentioned below:

A B C D E
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 currencies (dollars and pounds) separately.

Please help.