0

I have dates that look like this:

9/24/13
9/24/13
10/7/13
10/7/13
10/14/13
10/16/13
10/22/13
10/22/13
10/30/13

I need logic in a cell that will count the number of September occurrences. Then I need the same logic in another cell that will count the number of October occurrences. I need the finished product to look like this:

Sep-13 2
Oct-13 7

3
  • I'm assuming we are talking about Excel here? should there be a tag associated with it? Sep 17, 2014 at 15:59
  • Yes. thank you. It has been added. Also, the cells are A1:A9
    – Eric
    Sep 17, 2014 at 16:00
  • Do you want the month-year and count all in the same cell?
    – EStraka
    Sep 18, 2014 at 14:57

1 Answer 1

0

You could =sumproduct() to do this. Assuming your dates are a list from A1:A50 the following would calculate how many of them occur in October:

=SUMPRODUCT((MONTH(A1:A50)=10)*1)

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .