sumproduct
 

hi there,

I got error on below formula :
=SUMPRODUCT((D4:D15="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 D14:D15 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

sumproduct
 

Asterisk is not a wildcard in the SUMPRODUCT formula. Try
=SUMPRODUCT((LEFT(D4:D15,8)="sumatera")*(E4:E15="f lex")*(F4:F15="done")*(G4:G15<=J2)*(G4:G15=I2)) "Firman-EID" wrote in ... hi there, I got error on below formula : =SUMPRODUCT((D4:D15="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 D14:D15 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