I have a list of three important data. In column A I have a subject (math,
science, etc.), in column B I have a code for the one student who got it
right, and in column c I have the codes of any students who guessed wrong. I
want to create a list at the bottom of each individual students right and
wrong in each subject (i.e., Bob had 14 right in math, 8 wrong in math, 6
right in science... etc.). What combination of functions can I use to count
by means of the subject and the student's two-digit code? Thanks.