| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct for partial name?
I have a chart of accounts. All accounts have a hyphen separating the
main account and sub account. I have a sumproduct formula that returns the sum of all main & sub accounts such as Advertising- Billboards. But I need a sumproduct formula to return the total of all Advertising too. A formula that looks at the main account BEFORE the hyphen. Is that possible? Advertising-Radio Advertising-ROP Advertising-Direct Mail Advertising-Billboards Advertising-TV Advertising-Broadcast |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct with partial charcter matching | Excel Worksheet Functions | |||
| Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
| Sumproduct for partial text | Excel Worksheet Functions | |||
| sumproduct partial text count | Excel Worksheet Functions | |||
| Partial replace | New Users to Excel | |||
Threaded Mode
