| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help - sumif help on sales data between dates?
Hi,
I want to somehow pull through sales data for between two dates. I have the dates as 3/1/08 and the sales data has come through by week. How could i pull through the info for between two dates? EG : sales data looks like this Week 1 3000 Week 2 5000 But the dates i need are between 1.1.08 and 18.2.08 for specific products. I was planning on doing lookups to get the product, somehow linking to dates (Concatenate) but then i was lost in how to get sales BETWEEN two dates.... Any thoughts out there? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sales Order to Sales History Data | Excel Worksheet Functions | |||
| Linking Sales Order to Sales History Data | Excel Worksheet Functions | |||
| Sumif on pulling out data from dates | Excel Worksheet Functions | |||
| sales dates | Excel Discussion (Misc queries) | |||
| Sum of data between two dates - tried SUMIF and it returned "0" | Excel Worksheet Functions | |||
Threaded Mode
