View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
patrick
 
Posts: n/a
Default Summing inventory by quarter and product#

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