Calculating Various Currencies Seperately

Hi,

I would like a create worksheet to differenciate between entries in £GBP and in €EUR in a single column and give me seperate totals for both. I'm using Excel 2010.

The previous formula I was given was:

=sumcurrency("£",B1:B10) but this only returns ?name

Any help would be great

Appologies, See attached.

Currently it is only calculating each value as a single currency, if possible I would like it to calcualate only cells in € in one total box (in this case B33,C33,D33 & E33) and in a seperate totals box (in this case B36,C36,D36 & E36) calculates only cells with £ The purpose is to work out spendings in GBP and EUR seperatly

Hope this helps

thanks for the reply Sixthsense, I was hoping to avoid using the Supplier code as there is somethime crossovers as they have branched in the eurozone and in the UK which would cause problems with the formulas. I was hoping it could be done only on the columns using currecncies.

Greatly appreciate your help though.