| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
sum units sold every ten days
I have Excel 2007 and want to sum the number of units we sold every 10 days
between October 1 and December 31. The date fields from the invoices are formated mm/dd/yyyy, the units field is a number, and then the item description is text. I think I can do it with sumproduct() or sumifs() but the date variable giving me a headache. I thought about a different equation with the variable dates in 9 cells but thought I would ask the group. Any help is appreciated. Lee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF to calculate units sold in a specified timeframe | Excel Worksheet Functions | |||
| Reducing Quantity When an Item is Sold | Excel Discussion (Misc queries) | |||
| Numeric Rank By Qty Sold | Excel Discussion (Misc queries) | |||
| keep track of gift certificates sold | New Users to Excel | |||
| Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
Threaded Mode
