Countif with special criteria

[gtd526]

Hello,
Looking for the Count of W/L (D:D) based on the MIN/MAX Seed (J:J) of the 2 teams playing (B:B) for the entire range (Rows 2-25).
Thank you.

NBA.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Date	Team	SPRD	Results	MOV	Diff				Seed
2	5/1	MIL	4.5	W	12	16.5		CSF	Away	3
3		BOS	-4.5	L	-12	-16.5			Home	2		W/L record for Top seed of both teams
4		GSW	-1.5	L	1	-0.5			Away	3
5		MEM	1.5	W	-1	0.5			Home	2		get W/L per Seed of 2 playing teams
6		PHI	7.5	L	-14	6.5			Away	4		for the entire range D:D
7		MIA	-7.5	W	14	-6.5			Home	1		CSF		CSF
8		DAL	6	L	-7	-1			Away	4		Top Seed of 2 Teams		Bottom Seed of 2 Teams
9		PHO	-6	W	7	1			Home	1		W	L	W	L
10	5/3	MIL	5	L	-23	-18	with	CSF	Away	3		0	0	1	0
11		BOS	-5	W	23	18	against		Home	2		Test	Test	Test	Test
12		GSW	-1.5	L	-5	-6.5	against		Away	3
13		MEM	1.5	W	5	6.5	against		Home	2
14		PHI	9	L	-16	-7	against		Away	4		Away = Even
15		MIA	-9	W	16	7	with		Home	1		Home = Odd
16		DAL	6	L	-20	-14	against		Away	4
17		PHO	-6	W	20	14	against		Home	1
18	5/5	MIA	-3	L	-20	-23	with	CSF	Away	1
19		PHI	3	W	20	23	against		Home	4
20		PHO	1	L	-9	-8	against		Away	1
21		DAL	-1	W	9	8	against		Home	4
22		BOS	2	Psh	-2	0	against		Away	2
23		MIL	-2	Psh	2	0	against		Home	3
24		MEM	6.5	L	-30	-23.5	against		Away	2
25		GSW	-6.5	W	30	23.5	with		Home	3
My Bets (3)

Cell Formulas
Range	Formula
I2:I25	I2	=IF(MOD(ROW(),2)=1,"Home","Away")
J2:J25	J2	=INDEX('Playoff Favs'!NBARank,MATCH('My Bets'!$B2,'Playoff Favs'!NBATeam,0))
L10	L10	=COUNTIFS(D2:D3,"=W",J2:J3,MIN(J2:J3))
M10	M10	=COUNTIFS(D2:D3,"=L",J2:J3,MIN(J2:J3))
N10	N10	=COUNTIFS(D2:D3,"=W",J2:J3,MAX(J2:J3))
O10	O10	=COUNTIFS(D2:D3,"=L",J2:J3,MAX(J2:J3))

Named Ranges
Name	Refers To	Cells
'Playoff Favs'!NBAEast	='Playoff Favs'!$B$26:$B$35	J2:J25
Playoffs!NBAEast	='Playoff Favs'!$B$26:$B$35	J2:J25
'Playoff Favs'!NBAEastRank	='Playoff Favs'!$C$26:$C$35	J2:J25
Playoffs!NBAEastRank	='Playoff Favs'!$C$26:$C$35	J2:J25
'Playoff Favs'!NBARank	='Playoff Favs'!$C$26:$C$45	J2:J25
Playoffs!NBARank	='Playoff Favs'!$C$26:$C$45	J2:J25
'Playoff Favs'!NBATeam	='Playoff Favs'!$B$26:$B$45	J2:J25
Playoffs!NBATeam	='Playoff Favs'!$B$26:$B$45	J2:J25
'Playoff Favs'!NBAWest	='Playoff Favs'!$B$36:$B$45	J2:J25
Playoffs!NBAWest	='Playoff Favs'!$B$36:$B$45	J2:J25
'Playoff Favs'!NBAWestRank	='Playoff Favs'!$C$36:$C$45	J2:J25
Playoffs!NBAWestRank	='Playoff Favs'!$C$36:$C$45	J2:J25