Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |