close

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 INDIGO10
FR RH TAJ INDIGO5
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(quot;FR LHquot;,C88:C97,0)),D8897,0))}
Could anybody help me
--
Thanks,
Vikram P. Dhemare

Hi,

Maybe you can use the wildcard *

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

Regards,
Bondi

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄