Sports Betting Tracking Sheet - Sumproduct/countifs?

[wtfisgoingon23]

Hello,

I am trying to count/sum all the wins in column B (consensus picks win column) that match Players A, B and Consensus picks. Panthers -3 vs Cowboys is in players A, B and the consensus column and was a winner (1 in column B). That should count as 1. The correct formula should result in 2 (Panthers -3 vs Cowboys and Bears +7.5 @ Packers. Giants +3 vs Jaguars was a match for all the columns, but was not a winner)

I have tried SUMPRODUCT((ISNUMBER(MATCH), COUNTIFS and other methods but have not come up with the correct solution.

Any suggestions on how to do this?

Thanks,
Grant

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Consensus[/TD]
[TD]Win[/TD]
[TD]Player A[/TD]
[TD]Win[/TD]
[TD]Player B[/TD]
[TD]Win[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Chiefs +3.5 @ Chargers[/TD]
[TD]1[/TD]
[TD]Giants +3 vs Jaguars[/TD]
[TD]0[/TD]
[TD]Panthers -3 vs Cowboys[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Vikings -6.5 vs 49ers[/TD]
[TD]1[/TD]
[TD]Vikings -6.5 vs 49ers[/TD]
[TD]1[/TD]
[TD]Ravens -7.5 vs Bills[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Panthers -3 vs Cowboys[/TD]
[TD]1[/TD]
[TD]Lions -6.5 vs Jets[/TD]
[TD]0[/TD]
[TD]Bears +7.5 @ Packers[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Bears +7.5 @ Packers[/TD]
[TD]1[/TD]
[TD]Bears +7.5 @ Packers[/TD]
[TD]1[/TD]
[TD]Giants +3 vs Jaguars[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Giants +3 vs Jaguars[/TD]
[TD]0[/TD]
[TD]Panthers -3 vs Cowboys[/TD]
[TD]1[/TD]
[TD]Texans +6.5 @
Patriots[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

Welcome to the forum.

Try:

=SUMPRODUCT(B2:B6,COUNTIFS(C2:C6,A2:A6,D2:D6,1),COUNTIFS(E2:E6,A2:A6,F2:F6,1))

 

[wtfisgoingon23]

My main man Eric from Utah. I grew up in Cottonwood Heights, UT. That is exactly what I am looking for. I appreciate your help!!

 

[Eric W]

Glad to help!