Excel 2003, I have a row of Entries A,B,C,or D in from E2 through S2.
I have A,B,C, or D also in a row, E98 though S98. They are not necessarily
in the same order.
I need to sum the number of matches by row, that is if E2 matches E98, and
H2 matches H98, and S2 matches S98, I need a count of three.
If I change the entry in J2 to match what is in J98, the count should change
to four.
The original formula will go into cell C2. I will then fill this formula
down to row 96.

I cant seem to come up with a formula to do that.
Please help?
Pepper