Hi

i am trying to get Excel to tell me the number of times a value appears in
both column a and columb b. for example:

a a
a n
a a
m a
a a
m d

the result i am looking for excel to come up with is 3.

i have been trying for about 3 days now with no luck

does anyone have suggestions?

Thanks :)