sumif function with partially matchin sentences

V

Vikram Dhemare

Hi,
I have a Excel sheet which contents the daily despatch details for specific
parts like Fr LH ----, Fr RH ----, & so on. Now I want to sum for the value
contents Fr LH (i. e. for first / left 4 values being matched). I have been
tried this with sumif function but the value returns 0.
For yr ready ref. i am putting here the table:
Col. A Col. B
FR LH STD 160
FR RH STD 160
RR LH STD 158
RR RH STD 158
FR LH DIESEL 7
FR RH DIESEL 7
RR LH DIESEL 0
RR RH DIESEL 0
RR LH DLG 7
RR RH DLG 7
I have tried this :
=SUMIF(A1:A10,MATCH("FR LH",A1:A10,0),B1:B10)
But not working.
Could anybody help on this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumif function when left 4 texts are matching 1
ComboBox with multiple criteria 7
Can I combine Excel COUNTBLANK with another function? 2
Using SUMIF Function with a named cell reference as value in CRITE 3
Help with SUMIF, INDEX, LOOKUP Please !! 13
SUMIF function doesn't work with "date less than" cell reference 1

Top