I'm using Excel 2003 SP2. I need a formula that will tell me how many times
tests passed across multiple platforms. For instance, I have two columns; A
and B. Column A contains multiple platforms, ie: oracle, unix, mssql2K5.
Column B contains the results pass, fail, blocked.

ColA ColB
mssql2k5 pass
oracle pass
unix fail
mssql2k5 fail
oracle pass
unix fail
mssql2k5 blocked
oracle blocked
unix blocked


I can use COUNTIF and determine the number of pass/fail/blocked cases, and I
can determine the number of platforms tested on. What I can't seem to get is
the number of cases passed, etc. on mssql2K5, etc.

What I want is something like =COUNTIF(A:A,"mssql2k5") and
COUNTIF(B:B,"pass"). I tried using =COUNTIF(AND(AA:,"mssql2k5"),B:B,"pass")
, and the other way around, but that didn't work. Is this type of formula
possible?