View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob H[_2_] Bob H[_2_] is offline
external usenet poster
 
Posts: 12
Default DSUM Partial Match

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