sumif function when left 4 texts are matching
 

Hi,
Can I get sum, if the criteria value is partially matching (i.e. when the
fisrt 4 text values being matching)
DESC. QTY
FR LH TAJ INDIGO 10
FR RH TAJ INDIGO 5
FR LH 10
FR RH 5
RR LH 10
RR RH 5
FR LH 10
FR RH 5
RR LH 10
RR RH 5
I have tried this array function, but not working
{=SUM(IF(C88:C97=(MATCH("FR LH",C88:C97,0)),D88:D97,0))}
Could anybody help me
--
Thanks,
Vikram P. Dhemare

sumif function when left 4 texts are matching
 

Hi,

Maybe you can use the wildcard *

=SUMIF(C88:C97,"FR LH*",D88:D97)

Regards,
Bondi