software

Hi,
I have a Excel sheet which contents the daily despatch details for specific
parts like Fr LH ----, Fr RH ----, amp; 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 STD158
FR LH DIESEL7
FR RH DIESEL7
RR LH DIESEL0
RR RH DIESEL0
RR LH DLG 7
RR RH DLG 7
I have tried this :
=SUMIF(A1:A10,MATCH(quot;FR LHquot;,A1:A10,0),B1:B10)
But not working.
Could anybody help on this.
--
Thanks,
Vikram P. Dhemare

=SUMIF(A1:A10,quot;FR LH*quot;,B1:B10)

HTH
--
AP

quot;Vikram Dhemarequot; gt; a écrit dans le message de
...
gt; Hi,
gt; I have a Excel sheet which contents the daily despatch details for
specific
gt; parts like Fr LH ----, Fr RH ----, amp; so on. Now I want to sum for the
value
gt; contents Fr LH (i. e. for first / left 4 values being matched). I have
been
gt; tried this with sumif function but the value returns 0.
gt; For yr ready ref. i am putting here the table:
gt; Col. A Col. B
gt; FR LH STD 160
gt; FR RH STD 160
gt; RR LH STD 158
gt; RR RH STD 158
gt; FR LH DIESEL 7
gt; FR RH DIESEL 7
gt; RR LH DIESEL 0
gt; RR RH DIESEL 0
gt; RR LH DLG 7
gt; RR RH DLG 7
gt; I have tried this :
gt; =SUMIF(A1:A10,MATCH(quot;FR LHquot;,A1:A10,0),B1:B10)
gt; But not working.
gt; Could anybody help on this.
gt; --
gt; Thanks,
gt; Vikram P. Dhemare
Working
Thanxs
--
Vikram P. Dhemarequot;Ardus Petusquot; wrote:

gt; =SUMIF(A1:A10,quot;FR LH*quot;,B1:B10)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Vikram Dhemarequot; gt; a écrit dans le message de
gt; ...
gt; gt; Hi,
gt; gt; I have a Excel sheet which contents the daily despatch details for
gt; specific
gt; gt; parts like Fr LH ----, Fr RH ----, amp; so on. Now I want to sum for the
gt; value
gt; gt; contents Fr LH (i. e. for first / left 4 values being matched). I have
gt; been
gt; gt; tried this with sumif function but the value returns 0.
gt; gt; For yr ready ref. i am putting here the table:
gt; gt; Col. A Col. B
gt; gt; FR LH STD 160
gt; gt; FR RH STD 160
gt; gt; RR LH STD 158
gt; gt; RR RH STD 158
gt; gt; FR LH DIESEL 7
gt; gt; FR RH DIESEL 7
gt; gt; RR LH DIESEL 0
gt; gt; RR RH DIESEL 0
gt; gt; RR LH DLG 7
gt; gt; RR RH DLG 7
gt; gt; I have tried this :
gt; gt; =SUMIF(A1:A10,MATCH(quot;FR LHquot;,A1:A10,0),B1:B10)
gt; gt; But not working.
gt; gt; Could anybody help on this.
gt; gt; --
gt; gt; Thanks,
gt; gt; Vikram P. Dhemare
gt;
gt;
gt;