How to count by Date and Result

[relics]

Hello,

My name is Mike and I'm working on a file that has me a bit stumped. I appreciate any help that can be provided to solve this problem. It seems like it would be fairly straightforward, but it's just not coming to me.

I have two columns and need to calculate the number of "Early" and "Late" results in column B by the month and year (column A). In the example below, the formula would find that there were five early deliveries in January, 2015 and was one late delivery in January 2015. How would I go about doing this?

My apologies for not attaching the file to this thread. I cannot upload from here.

Any help would be greatly appreciated.

Column A Column B
6/16/2013 LATE
11/14/2014 LATE
1/29/2015 EARLY
4/8/2013EARLY
4/8/2013EARLY
11/14/2014EARLY
11/14/2013EARLY
11/14/2014EARLY
3/9/2014LATE
3/9/2014EARLY
5/15/2015EARLY
5/15/2015LATE
1/14/2015EARLY
1/14/2015EARLY
1/14/2015LATE
1/14/2015EARLY
1/14/2015EARLY
12/18/2014EARLY
12/18/2014EARLY
1/26/2015LATE

 

[tomas]

the fastest way is pivot table, put date into rows , right click group by years. Put column B to columns and then to values section as well.

something like that

 

[Luke M]

You could solve this using a PivotTable or formulas. A PivotTable would be faster, and would be my reccomendation.