Home |
Search |
Today's Posts |
#1
|
|||
|
|||
compare one row to another and sum the result
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks Dave,
Very close but I don't understand (--( can you explain? I get a result that is not correct Russell "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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
=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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
Simply fantastic, UR a life saver.
Russell "Dave Peterson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|