| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif function with partially matchin sentences
Working
Thanxs -- Vikram P. Dhemare "Ardus Petus" wrote: =SUMIF(A1:A10,"FR LH*",B1:B10) HTH -- AP "Vikram Dhemare" a écrit dans le message de ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| SumIF function | Excel Discussion (Misc queries) | |||
| Sumif function with remote cell references | Excel Worksheet Functions | |||
| how do you do a sumif function on more than one worksheet? | Excel Worksheet Functions | |||
Threaded Mode
