CountIFS or SUMPRODUCT

[gtd526]

Hello,

If all 4 are True = 1 count.
Line 5 vs Line 6
B5 ="W"
X5 <X6
Y5 >Y6
Z5 >Z6
Line 6 should count 1.

Then 7 vs 8, 9 vs 10, 11 vs 12, etc.
In groups of 2.
Row count is 5:30

thanks

NBA.xlsm
	X	Y	Z
4	NRtg/A	Ortg/A	DRtg/A
5	7.2	111.01	102.92
6	6.76	113.75	106.26
7	-7.62	101.35	111.49
8	-7.35	107.22	115.33
9	2.45	105.13	104.59
10	8.15	114.39	111.12
11	-0.37	112.33	107.66
12	-7.19	104.23	118.52
13	-1.3	109.62	105.03
14	-8.33	98.67	110.89
15	-6.16	102.30	110.07
16	-3.27	107.51	106.63
17	11.26	114.52	100.1
18	5.49	111.84	113.18
Favs

Cell Formulas
Range	Formula
X5:X18	X5	=IFERROR(VLOOKUP($A5,TeamRankings!$CC:$CN,12,0),"")
Y5:Y18	Y5	=VLOOKUP(A5,TeamRankings!$CC$3:$CP$32,14,0)
Z5:Z18	Z5	=VLOOKUP(A5,TeamRankings!$CC$3:$CQ$32,15,0)

 

[gtd526]

Hello,

If all 4 are True = 1 count.
Line 5 vs Line 6
B5 ="W"
X5 <X6
Y5 >Y6
Z5 >Z6
Line 6 should count 1.
--and--
B6 ="W"
X6 <X5
Y6 >Y5
Z6 >Z5

Then 7 vs 8, 9 vs 10, 11 vs 12, etc.
In groups of 2.
Row count is 5:30

thanks

NBA.xlsm
	D																				X	Y	Z
4	~W/L																				NRtg/A	Ortg/A	DRtg/A
5																					7.2	111.01	102.92
6	W																				6.76	113.75	106.26
7																					-7.62	101.35	111.49
8	L																				-7.35	107.22	115.33
9	W																				2.45	105.13	104.59
10																					8.15	114.39	111.12
11																					-0.37	112.33	107.66
12	L																				-7.19	104.23	118.52
13																					-1.3	109.62	105.03
14	L																				-8.33	98.67	110.89
15																					-6.16	102.30	110.07
16																					-3.27	107.51	106.63
17	W																				11.26	114.52	100.1
18																					5.49	111.84	113.18
Favs

Cell Formulas
Range	Formula
X5:X18	X5	=IFERROR(VLOOKUP($A5,TeamRankings!$CC:$CN,12,0),"")
Y5:Y18	Y5	=VLOOKUP(A5,TeamRankings!$CC$3:$CP$32,14,0)
Z5:Z18	Z5	=VLOOKUP(A5,TeamRankings!$CC$3:$CQ$32,15,0)

 

[alz]

If all 4 are True = 1 count.
Line 5 vs Line 6
B5 ="W"
X5 <X6
Y5 >Y6
Z5 >Z6
Line 6 should count 1.
=COUNTIFS(B5,"W",X5,"<"&X6,Y5,">"&Y6,Z5,">"&Z6)

Countifs will get better speed for the larger spreadsheet :