I have a list of events that take place in two years, this and last. I need a formula to count what month and year thing take place.
For example:
If I have 5 things happen in January, 3 last year and 2 this year. And I have 3 things happen in April, 1 last year and 2 this year.
This is displayed in column A.
[A]
Event Date
Jan-09
Apr-09
Jan-09
Apr-10
Jan-09
Jan-10
Apr-10
Jan-10
In column B and C I would like it to display.
[B]--------[C]
[Jan-09]-[3]
[Apr-09]-[1]
[Jan-10]-[2]
[Apr-10]-[2]
This is the formula I have tried to use.
=SUM(IF(MONTH($A$2:$A$100)=MONTH(B4),1))
push: Ctrl+Shift+Enter
I changed it like this:
=SUM(IF(AND(MONTH($A$2:$A$100)=MONTH(B4),YEAR($A$2:$A$100)=YEAR(B4)),1))
push: Ctrl+Shift+Enter
Thank you, so much.
P.S. Also if some could explain what pushing Ctrl+Shift+Enter does or where i can find it that would be great. But not needed.
Bookmarks