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