sumif function when left 4 texts are matching

[Vikram Dhemare]

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)),D8897,0))}
Could anybody help me

 

[Bondi]

Hi,

Maybe you can use the wildcard *

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

Regards,
Bondi