| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change INSERT FUNCTION icon left of formula bar to = sign? | Setting up and Configuration of Excel | |||
| basic sumif function help (urgent) | Excel Worksheet Functions | |||
| Improve SUMIF function to sum more than one column | Excel Worksheet Functions | |||
| sumif function with a difference | Excel Worksheet Functions | |||
| how do you do a sumif function on more than one worksheet? | Excel Worksheet Functions | |||
Linear Mode
