I have a spreadsheet that records the initials of a stage check airman in one
column, the next column can be marked with an X if the student fails the oral
portion, the next column marked with an X if they fail the flight portion. I
want to count the number of times the initials are found with no X's in
either column (which means the student passed the check) and also count the
number of times the initials are found with either column having an X in it.

Any suggestions?