How about:

=SUMPRODUCT(--($B$1:$G$1=B3:G3))
and copy down.

foxwave wrote:

I have text in row B1:G1, and similar text in rows B3:G10.
If results in A1:G1 equals data in A3:G10 i want to sum the result of
matches in each row in column H
RESULT win win loss loss win SCORE

paul loss win win win loss
kim loss loss win win win

Hoping someone can help
Russell

--

Dave Peterson