Thread: DSUM
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ED007 ED007 is offline
external usenet poster
 
Posts: 5
Default DSUM

I have a table with 4 columns.
DATE, MOLD, SOURCE, PARTS

(DATE IS A DATE, MOLD AND SOURCE ARE TEXT, AND PARTS IS NUMERIC)

I have a second table that contains.
DATE, MOLD, SOURCE2, GROSS

(DATE IS A DATE, MOLD AND SOURCE2 ARE TEXT, AND GROSS IS NUMERIC)

What I want is a function that I can place in the 5 colum of the second
table that would sum all the values in the parts column of the first table
were the DATE and MOLD match the DATE and MOLD on the corrisponding row of
the second table.

I thought I could get there with DSUM but I am having no luck.