Countifs by Month, Year, and Event

I am trying to create a report from a long list of data (which continues to grow) where I can list and chart the number of events by month and year. I tried the formula:

Formula:

Please Login or Register  to view this content.

but Excel doesn't like the format.

I have attached a sample spreadsheet which has the data on tab 1 and the report on tab 2. I have a section on tab 2 for the expected results (only for Jan and Feb though).

Thank you in advance for any assistance you can give me.

Cliff

In B3:
=COUNTIFS(Sheet1!$A:$A,">="&DATE($X$1,MONTH(($A3&1)+0),1),Sheet1!$A:$A,"<="&EOMONTH(DATE($X$1,MONTH(($A3&1)+0),1),0),Sheet1!$K:$K,B$2)

Copy down to B14 & across to column G.

Thank you CK76 and Tony Valko.

CK76, this worked perfectly and is exactly what I needed.

Thank you again!!!!