Hello Excel Forum!
I have column A1:A300 containing various dates from 2015. I have a summary page where I am trying to 'count' how many times a specific month shows up. For example:
Column A
26-Jan-2015
13-Sep-2015
22-Apr-2015
21-Jan-2015
I then have a summary chart as follows:
Column B_______Column C
Date___________No. of Occurences
January 2015
February 2015
etc.
In column C, I tried the following formula but I am receiving a #VALUE! error, =SUMPRODUCT(--(MONTH($A$1:$A$300)=1)).
Any suggestions as to where I'm going wrong!?
Thanks a lot.
MM
Bookmarks