software

hi there,

I got error on below formula :
=SUMPRODUCT((D415=quot;sumatera
*quot;)*(E4:E15=quot;flexquot;)*(F4:F15=quot;donequot;)*(G4:G15lt;=J2)*( G4:G15gt;=I2)) --gt; 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 quot;sumateraquot; only. In the range of D1415 there are quot;sumatera
baratquot;, quot;sumatera utaraquot;, quot;sumatera tengahquot; and etc started with quot;sumatraquot;.
What i want is the formula could filter as above formula but it's not
working. Please help me how to use the right quot;sumproductquot; for this case.

Thank you,
Firman-EID

Asterisk is not a wildcard in the SUMPRODUCT formula. Try
=SUMPRODUCT((LEFT(D415,8)=quot;sumateraquot;)*(E4:E15=quot;f lexquot;)*(F4:F15=quot;donequot;)*(G4:G15lt;=J2)*(G4:G15gt;=I2)) quot;Firman-EIDquot; gt; wrote in ...gt; hi there,gt;gt; I got error on below formula :gt; =SUMPRODUCT((D415=quot;sumateragt; *quot;)*(E4:E15=quot;flexquot;)*(F4:F15=quot;donequot;)*(G4:G15lt;=J2)*( G4:G15gt;=I2)) --gt; theresultgt; is : 0 (it shlud be 51).gt;gt; but once when i delete the asterisk (*), everthing is fine but the formulagt; is just take for quot;sumateraquot; only. In the range of D1415 there arequot;sumateragt; baratquot;, quot;sumatera utaraquot;, quot;sumatera tengahquot; and etc started withquot;sumatraquot;.gt; What i want is the formula could filter as above formula but it's notgt; working. Please help me how to use the right quot;sumproductquot; for this case.gt;gt; Thank you,gt; Firman-EID