have a look in help index for COUNTIF

--
Don Guillett
SalesAid Software

"Colin Thornton" wrote in message
...
I am trying to count the number of occurrences that data in two columns
match

A B C D E
1

2 Colin Yes SE

3 Sue Outside Mid

4 Mary Inside SE

5 Julie Yes SE

6 Mark Yes Mid

7 Fiona Outside SE

For example i want to count the number of times "Yes" appears along side
"SE"


Hope you can help.

Colin