comparing two letter (grades) values

Hi guys,

I'm trying to compare two columns which contain a TARGET GRADE and a PREDICTED GRADE and do a count on how many grades in the TARGET GRADE column are greater/less than in the PREDICTED GRADE column.

I normally use the SUMPRODUCT function ... something like below (to count how many grades in both columns are greater than C Grades).

=SUMPRODUCT(--(LEFT(C2:C110)<="C"),--(D2:D110<="C"))

but that won't work with what I need to do above? or will it?

Hope my question is clear.