| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif
please help me
in column A the range Itm contains ticker like A1 car.3 A2 mobile A3 battery A4 mobile.3 A5 mobile A6 battery A7 car A8 mobile.1 A9 car A10 mobile and so on€¦up to over thousand item in column B the range Amt contains numbers like B1 -3,589 B2 2,587 B3 -489 B4 2,587 B5 -5,687 B6 1,178 B7 567 B8 -9,642 B9 44,330 B10 13,897 No problem to me to sum those items with the dot "." for example =sumif(Itm,"*.3",Amt) I need help please to sum amounts of those which do not have the dot "." like the ( battery ) and ( mobile ) many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
| SumIf with an Or | Excel Worksheet Functions | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Threaded Mode
