sumproduct

[Guest]

hi there,

I got error on below formula :
=SUMPRODUCT((D415="sumatera
*")*(E4:E15="flex")*(F4:F15="done")*(G4:G15<=J2)*(G4:G15>=I2)) --> the result
is : 0 (it shlud be 51).

but once when i delete the asterisk (*), everthing is fine but the formula
is just take for "sumatera" only. In the range of D1415 there are "sumatera
barat", "sumatera utara", "sumatera tengah" and etc started with "sumatra".
What i want is the formula could filter as above formula but it's not
working. Please help me how to use the right "sumproduct" for this case.

Thank you,
Firman-EID

 

[Bob Umlas]

Asterisk is not a wildcard in the SUMPRODUCT formula. Try
=SUMPRODUCT((LEFT(D415,8)="sumatera")*(E4:E15="flex")*(F4:F15="done")*(G4:G15<=J2)*(G4:G15>=I2)) "Firman-EID" <[email protected]> wrote in messagehi there,>> I got error on below formula :> =SUMPRODUCT((D415="sumatera> *")*(E4:E15="flex")*(F4:F15="done")*(G4:G15<=J2)*(G4:G15>=I2)) --> theresult> is : 0 (it shlud be 51).>> but once when i delete the asterisk (*), everthing is fine but the formula> is just take for "sumatera" only. In the range of D1415 there are"sumatera> barat", "sumatera utara", "sumatera tengah" and etc started with"sumatra".> What i want is the formula could filter as above formula but it's not> working. Please help me how to use the right "sumproduct" for this case.>> Thank you,> Firman-EID