Counting Matched Values

[Pepper]

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

 

[T. Valko]

Try this

=SUMPRODUCT(--(E2:S2=E98:S98))

 

[Pepper]

I tried sumproduct, but never created the correct syntax. More work on it to
come.
Thank you very much

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

I tried sumproduct, but never created the correct syntax. More work on it
to
come.
Thank you very much