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

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

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
>

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
>

=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

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
>

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

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
>