The_Rock
Board Regular
- Joined
- Jul 2, 2007
- Messages
- 174
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:
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![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
FYI I didn't create the original 123 sheet.
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:
Code:
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
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.