SUMIF with multiple selection criteria problem

Hi guys,
I need to use SUMIF with more than one criteria, and I'm having problems. I'm not an expert with Excel formulas, and although I found a site that (supposedly) explained how to get round this problem (using DSUM), I couldn't make sense of it. I'll try to explain my situation in plain English...

My spreadsheet contains 2 ranges of data (one from System X & one from System Y) to be reconciled.

Column A contains the currency of the deal from System X.
Column B contains the type of deal from System X.
Column C contains the amount of the deal from System X

Column E contains the currency of the deal from System Y.
Column F contains the type of deal from System Y.
Column G contains the amount of the deal from System Y.

Now, what I need is for Column D to Sum all amounts from Column G where the deal type in Column F is equal to the deal type in Column B AND the currency in Column E is equal to the currency in Column A.

I hope this makes sense, as I can barely get my head round it myself.

If anyone knows the solution, your advice would be greatly appreciated.

Many thanks,
Jon

It sounds like this thread will point you in the right direction.

SUMIF tests one condition.
SUMPRODUCT is used to test multiple conditions.

Thanks Mike, that's exactly what I was after.