counting conditionally formatted columns

Hi,

I'm new to this forum and have looked around for help with a problem. I've come up with part of the solution based on my reading so I'm thankful already.

I have a spreadsheet in which I've put in students answers and conditionally formatted them to be red if their answers are wrong. There are three types of answers--correct (in black), wrong (in red), and blank , where the students did not answer. I'm trying to figure out how to count the different answers. So far, I have gotten the answer on how to count the correct answers and this is the formula I used:

=SUMPRODUCT(--(B2:B49=$B$2:$B$49))

How do I now count the wrong answers (including the blanks) and also the blanks (on its own)?

Edit: I've attached a sample spreadsheet of what I need to get.

Thank you in advance for your help.

won't
=SUMPRODUCT(--(B2:B49=$B$2:$B$49)) always return 48?
what are the three conditions you have used?

all the wrong answers is =SUMPRODUCT(--(D2:D49<>$B$2:$B$49)) or =48-SUMPRODUCT(--(D2:D49=$B$2:$B$49))
all the blanks are ,not sure which is the column with 48 answers is here lets assume its col D and students answers in col b
=COUNTIF(b2:b49,"=") will count blanks in col b