How about:
=SUMPRODUCT(--($B$1:$G$1="win"),--(B3:G3="win"))
foxwave wrote:
Thanks again Dave,
I'm trying to count the number of "wins" in B3:G3 that match A3:G3.
A3:G3 is the team result and C3:G3 is the picks made by peolpe.
"Dave Peterson" wrote:
=sumproduct() likes to work with numbers.
the -- converts true's and false's to 1's and 0's.
Are you trying to just count the number of wins?
If yes:
=countif(b3:g3,"win")
I'm not quite sure what you're looking for.
foxwave wrote:
this result does work, however it does not distingush between "win" & "loss"
"Dave Peterson" wrote:
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
--
Dave Peterson
--
Dave Peterson
|