L

#### LiAD

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