Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DSUM with dates??
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates showing are not what I type | New Users to Excel | |||
Dates and Intervals | Excel Worksheet Functions | |||
formula to add dates. | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |