Needing Help converting SUMIF to SUMPRODUCT

C

Cypris

Joined
Sep 26, 2008
Messages
1
Reaction score
0
SUMIF('DATA SHEET'!$A:$A,($B$1 & $B9 & $F$2 & $F$3),'DATA SHEET'!B:B)

the range section, for example, will evaluate to "37210904133",
(i know i could use CONCATENATE, but GridMagic doesn't support it so im using that method instead)

DATA SHEET contains this line for "37210904133":

37210904133 16 17 20 25 20 17 17
(First Col = A, last = H)

The end result is "16",
Any idea how to do this in SUMPRODUCT? (or any other function supported by GridMagic
( Function List http://www.simprit.com/community/viewtopic.php?p=614 )


Thanks
 
Back
Top