If anyone can help me out with this it would be greatly appreciated. I have been banging my head on this for a long time now.

I have what amounts to a sheet that looks like this:

'Open Date' 'Close Date' 'Product'
January 3, 2006 January 5, 2006 ProductZ


I have some three thousand of these rows detailing open close and product.

What I need to do is generate some charts, and obviously first I need to figure out how to do the math. I want to have the following details.

ProductZ
Open Close
January x y
February x y
March x y
.
.
.
December x y

Any suggestions would be greatly appreciated.

I know how to count each item that has January as a month, and I know how to count each item that has a specific product, but I don't know how to combine the two functions.