+ Reply to Thread
Results 1 to 2 of 2

sumif function when left 4 texts are matching

  1. #1
    Vikram Dhemare
    Guest

    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

  2. #2
    Bondi
    Guest

    Re: sumif function when left 4 texts are matching

    Hi,

    Maybe you can use the wildcard *

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

    Regards,
    Bondi


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1