In Excel 2003, is there a way to combine the functions COUNTIF(A1:A10,"Joe")
and COUNTIF(B1:B10,"5")? In other words, the array in Cols A and B has
scores from 0 to 10 for multiple trials by Joe, Bill, and Jane; I want a
count of all of Joe's scores that are over 5.