Hi all, I am new to this website so please bear with me. I am trying to collate information from four columns in excel.

The information is a list of amounts, dates and currencies and rates. I was thinking a sumif function?? The data is in no particular order. I need to show a total of each date per currency.

I would like to avoid macros if possible. The data I have at the moment is below

CCY..........Amount............Date.............Rate
USD..........200,000..........01/03/11..........0.50
USD..........100,000..........01/03/11..........0.50
EUR..........75,000............01/04/11..........0.30
USD..........50,000............01/04/11..........0.60
EUR..........100,000..........01/05/11..........0.40
USD..........100,000..........01/03/11..........0.50

I am looking for a final sheet of...

CCY..........Amount.............Date.............Rate
USD..........400,000..........01/03/11..........0.50
USD..........50,000............01/04/11..........0.60
EUR..........75,000............01/04/11..........0.30
EUR..........100,000..........01/05/11..........0.40

I'm sorry for the longwinded explanation!!

Kind regards
BW