| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM Partial Match
Thank you both very much for the quick and accurate solution
"Bob H" wrote: I have a list of companies in col A and Revenues in column B. There are several rows with revenue for the same comapny so I want to use DSUM to get a total revenue per company. My problem is that DSUM adds together all revenues fo companies that begin with the same letters even if though there is an exact match. For example, if my company name criteria is "A", DSUM adds together companies A, AB, ABC, Acme, etc. Does anyone know a way to force DSUm to inly sum an exact match? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Partial match lookup question | Excel Worksheet Functions | |||
| Partial Address match in an array | Excel Discussion (Misc queries) | |||
| partial lookup/match | Excel Worksheet Functions | |||
| partial/absolute text match | Excel Worksheet Functions | |||
| sumif based on partial match | Excel Worksheet Functions | |||
![Bob H[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
