| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif and left
Hi,
This works for your posted data =SUMPRODUCT((INT(A1:A10/100))*(B1:B10)) Mike "Bonita" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
