Counting products delivered by month

**gdi2k** · 07-25-2007, 02:29 AM

We sell a relatively small number of large products, delivered to clients over years.

I want to count which products were delivered in which month. To keep things simple, I have two columns:

Column A contains the product ID
column B contains the date of delivery to client

I want to create a table with the count of the products delivered per month:

Please Login or Register  to view this content.

And so forth.

I thought I could achieve this by duplicating the date column, changing the format to just show the month and year, then doing =countif(delivery_month,"Sep-2006"), but this returns a zero value, presumably because Excel sees the date as a number, not a lump of text.

What's the better way to go about this?

Thanks,

GDI

**JR@SGC** · 07-25-2007, 03:57 AM

Hi,

I dont know if there is another way but you can use an array formula,
For this you will need to reference the year of delivery as well. See attached.

The formula below is correct in reference to the attached.

Please Login or Register  to view this content.

When you enter the formula you need to click on the formula as if you were editing it and press control shift and enter. This refreshes the forumla.

Hope it helps

**gdi2k** · 07-25-2007, 08:50 AM

Hi JR,

Thanks for your help! This wasn't exactly what I was after (I think I explained it badly), but you did enlighten me to the YEAR and MONTH functions, which allowed me to split the delivery date into year and month columns; then I could run a DCOUNTA against the sheet specifying a month and a year, which was what I was trying to achieve. Long winded creating a new criteria for each month, but it works.

Thanks again,

Graham