ExcelBanter - View Single Post

Franz Verga

wrote:
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.

Maybe you can try with SUMPRODUCT function, but I think you should also
rethink the layout of your data... But this is just an opinion...

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy