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
|