Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello everybody I am using Excell 2003 and any help with the following would
be greatly appreciated. I have a worksheet containg a long list of various order information. Each row is an individual order. Column C contains the quantity, Column E the ship date, Column N the product number, and Column O contains a formula that adds .5 to the quantity from Column C and displays the result. I am hoping for a formula that will sum Column O if Column N is a specific product number and Column E falls within a certain range of dates(quarters). With this formula we could show the quantity for each product by quarter. Is this doable? Thanks! patrick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions |