I have seen similar answers below but for some reason i can't get the other
approaches to work for my problem. I have a list of data in coumns A and B
which I need to count how many times certain combinations occur. For example:

6 M
6 M
7 M
8 E
9 M

Results: 6 and M - 2, 7 and M - 1, 8 and M - 0, 8 and M - 1 etc

I need excel to count the number of times that the cells have a combination
of say 6 and M or 8 and E for example. I have tried an AND with a countif
but without any success.

What is the simplest way to do this?

As a slight extension of this the numbers 6,7,8 etc come from a =month(a52)
formula for example. Ideally I would like a formula that looks does exactly
the same thing but counts the number of matches in June and M etc


1-Jun-07 M
2-Jun-07 M
10-Jun-07 M
12-Jun-07 E
2-Jul-07 M
12-Jul-07 M
12-Jul-07 M

In this case results would be-
June and M - 3, June and E - 1, July and M - 3

Is this getting to fancy or I am best to stick to extracting the month
sequence number and matching with that?

Thanks
LD