I have not installed my 2007 yet since I got the freebie install once from
the intro, but
What happens when saved to older version?

--
Don Guillett
SalesAid Software

"Teethless mama" wrote in message
...
If you use Xl 2007 then try this:

=COUNTIFS(A:A,"Door Open",B:B,"Tech Fault")


"Anita" wrote:

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