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