I have been creating a spreadsheet in Excel to track warranty sales for
my business. On this sheet i need to keep track of the Date, Associate
who sold it (by employee number), the ammount sold, Month to date
sales, and average dollar ammount.

Each day in the table consists of 2 columns. One with The date as the
title, and the other as "associate" as the title. In order to figure
out what the month to date, and average sales are i need excel tosearch
this table by an associate number (off of a seperate report sheet) then
have it adjust to add the totals in the column to the left, the date
column, which actually shows the sales amount. I have been trying with
multiple DSUM functions, and even with long sumif functions without
luck, does anyone know how i can accomplish this?

It is a rather long table, probably 40-50 columns. and set up similar
to this

7/21 associate 7/22 associate 7/23 associate
15.99 46465 4.99 484878 5.99 798765

22.99 46565 8.99 65686 4.99 65686


and ultimatly i need to be able to locate an associate (65686) and sum
his totals for the entire month (8.99+4.99) and show this on the report
page.