I am trying to find the count of all the cells that have an F in one column
and also have an A in another column and I'm getting an error. I hope Excel
can do this with a simple formula. I don't do macros.

Here's an example:

1 A F
2 B F
3 A P
4 A N/A
5 B P
6 A F

Basically I am trying to determine how many "A" level requirement have
Passed, how many have Failed, how many are N/A and the same for the B level
requirements. I've already tallied the total Fails and Passes with a countif
for each column. Now I need to find how many of the Fails are As, Bs and Cs.
Same for the Passes. Tell me it's simple!