Counting Matched Values
 

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

Counting Matched Values
 

Try this

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

--
Biff
Microsoft Excel MVP


"Pepper" wrote in message
...
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

Counting Matched Values
 

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

"T. Valko" wrote:

Try this

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

--
Biff
Microsoft Excel MVP


"Pepper" wrote in message
...
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

Counting Matched Values
 

You're welcome!

--
Biff
Microsoft Excel MVP


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

"T. Valko" wrote:

Try this

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

--
Biff
Microsoft Excel MVP


"Pepper" wrote in message
...
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