DSUM with dates??
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. |
DSUM with dates??
|
All times are GMT +1. The time now is 07:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com