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.
--
Thanks,
Vikram P. Dhemare