DSUM from Lotus 123 to Excel

[The_Rock]

Hi folks,
I've been searching hard for an answer to this but cannot figure it out. I'm hoping your genius minds will have the solution to this.

I'm in the process of updating a 123 sheet to Excel. I have the following data;
Column E = Opportunity
Column F = Row
Column G = Amount
Column H = Curr
Column I = No Header (but is the formula of the DSUM)
Column J = Empty Column
Column K = No Header (but the 'criteria' for the DSUM)

Column:

    E                 F             G            H          I             J           K
Opportunity	     Row	  Amount	Curr			
1JF-QFXA7	1JF-QFXAB	34654.43         DKK    34654.43	        1JF-QFXAB
1JF-ELGER	1JF-EM84M	34748.00	 EUR	69496.00		1JF-EM84M
1JF-ELGER	1JF-EM84M	34748.00	 EUR	69496.00		1JF-EM84M
1JF-P3PKD	1JF-P3PKN	31754.21	 EUR	95262.63		1JF-P3PKN
1JF-P3PKD	1JF-P3PKN	31754.21	 EUR	95262.63		1JF-P3PKN
1JF-P3PKD	1JF-P3PKN	31754.21	 EUR	95262.63		1JF-P3PKN
1JF-13YAO9	1JF-13YAOV	17895.00	 GBP	17895.00		1JF-13YAOV
1JF-1DXZPJ	1JF-1DXZPR	25310.06	 EUR	75930.18		1JF-1DXZPR
1JF-1DXZPJ	1JF-1DXZPR	25310.06	 EUR	75930.18		1JF-1DXZPR
1JF-1DXZPJ	1JF-1DXZPR	25310.06	 EUR	75930.18		1JF-1DXZPR
1JF-142YPP	1JF-142YPX	65240.00         EUR    65240.00	        1JF-142YPX

The formula in 123 correctly sums up the 'Amount' (Column I) based on the fields in Column K: @DSUM($E$1:$G$12,"AMOUNT",ROW=$K2)

I am trying to convert this to Excel. I'm having problems trying to write criteria 'ROW=$K2' for Excel.

Appreciate any help

FYI I didn't create the original 123 sheet.

 

[Gerald Higgins]

How about dumping it all into a Pivot Table ?

 

[The_Rock]

There are more columns and I need to show all the data so we have line item detail.
Unfortunately, the pivot table won't give me what I need.

Any other idea's guys?