| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif and left
col a col b
103 100 204 500 need to sum col b based on the first left character of col a ie 1 100 2 500 -- Bonita |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif or sumproduct with a left statement | Excel Discussion (Misc queries) | |||
| Sumif/vlookup/left | Excel Discussion (Misc queries) | |||
| SUMIF and LEFT and Named Ranges | Excel Worksheet Functions | |||
| SUMIF and LEFT and Named Ranges | Excel Worksheet Functions | |||
| SUMIF and LEFT and Named Ranges | Excel Worksheet Functions | |||
Threaded Mode
