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

In the grander scheme of things there are two possibilities here. My favorite
would be to use a pivot table. It will allow you to aggregate (sum, or
average or...) your data exactly the way you want. Additionally you can group
your dates into a time series by month, quarter, year... and get your
subtotals and grand totals and... You can even format the pivot table to make
it look fancy.

The other option would be to use a sumproduct formula. Here is a good
reference on how to do that...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"patrick" wrote:

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