try this idea
=sumproduct((a2:a22="door open")*(b2:b22="tech fault"))

--
Don Guillett
SalesAid Software

"Anita" wrote in message
...
I have a spreadsheet with 2 columns like this:-

Incident Cause
Door Open Tech Fault
Door Open Public Error
Door 1st Catch Public Error
Door Open Tech Fault

What I want to do is count the number of (for instance) tech faults for
door
open or public errors for door open or public errors for door 1st catch
etc
etc. In other words count the number of causes for each incident.

Hope that makes sense and hope you can help.

Using Excel XP

Thanks

Anita