Excel counting dates

  GlasgowMary 11:32 15 Sep 05

I would like to use the countif funcion to count how many times a product appears in a column by month. For example, I have two columns - Date & Product. The dates span over one year and I would like to know how many times a product appears each month.

Hope you can help.

Thanks, Mary

  VoG II 11:56 15 Sep 05

Assuming dates in column A and product names in column B:

To count the number of product X sold in September (Month 9)


  GlasgowMary 14:17 15 Sep 05

Hi VoG,

Thanks so much for solving this for me. You have an amazing knowledge of the MS Software.


This thread is now locked and can not be replied to.

How to watch Surface PC live stream | Surface PC release date, price, spec rumours: All-in-one…

1995-2015: How technology has changed the world in 20 years

Best Photoshop video tutorials: 8 video tutorial websites for Photoshop

Apple's event invitations decoded: A look back at 16 of Apple's most cryptic invites | Clues in…