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

	A	B	C	D	E	F
1	Consensus	Win	Player A	Win	Player B	Win
2	Chiefs +3.5 @ Chargers	1	Giants +3 vs Jaguars	0	Panthers -3 vs Cowboys	1
3	Vikings -6.5 vs 49ers	1	Vikings -6.5 vs 49ers	1	Ravens -7.5 vs Bills	1
4	Panthers -3 vs Cowboys	1	Lions -6.5 vs Jets	0	Bears +7.5 @ Packers	1
5	Bears +7.5 @ Packers	1	Bears +7.5 @ Packers	1	Giants +3 vs Jaguars	0
6	Giants +3 vs Jaguars	0	Panthers -3 vs Cowboys	1	Texans +6.5 @ Patriots	0

<tbody>
</tbody>

 

[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!