Count duplicates

[gtd526]

Hello,
Not counting duplicates at this time. How can you count duplicates? Heres what I'm using. AC 9&10=count. Comparing 2 rows for count.
thanks

NBA.xlsm
	L		N	O		Q				U	V		X	Y	Z			AC
9	27		33%	-7.6		-13.3				1.58	0.57		-12.94	101.57	115.51			0
10	12		33%	-3.6		0.0				1.901	0.671		-0.2	113.99	120.61			8
Favs

Cell Formulas
Range	Formula
L9:L10	L9	=IFERROR(VLOOKUP($A9,TeamRankings!$AT$3:$AV$33,3,0),"")
N9	N9	=IFERROR(VLOOKUP(A9,TeamRankings!BN2:BQ33,4,0),"")
O9:O10	O9	=IFERROR(VLOOKUP(A9,TeamRankings!$BN$3:$BS$33,6,0),"")
Q9:Q10	Q9	=IFERROR(VLOOKUP(A9,TeamRankings!$BN$3:$BR$32,5,0),"")
N10	N10	=IFERROR(VLOOKUP(A10,TeamRankings!BN2:BQ33,4,0),"")
U9	U9	=IFERROR(VLOOKUP(A9,TeamRankings!J3:M32,4,0),"")
V9:V10	V9	=IFERROR(VLOOKUP(A9,TeamRankings!S:V,4,0),"")
X9:X10	X9	=IFERROR(VLOOKUP($A9,TeamRankings!$BT:$CE,12,0),"")
Y9:Y10	Y9	=IFERROR(VLOOKUP(A9,TeamRankings!$BT:$CG,14,0),"")
Z9:Z10	Z9	=IFERROR(VLOOKUP(A9,TeamRankings!$BT:$CH,15,0),"")
AC9	AC9	=COUNTIF(L9,"<"&L10)+COUNTIF(N9,">"&N10)+COUNTIF(O9,">"&O10)+COUNTIF(Q9,">"&Q10)+COUNTIF(U9,">"&U10)+COUNTIF(V9,">"&V10)+COUNTIF(X9,">"&X10)+COUNTIF(Y9,">"&Y10)+COUNTIF(Z9,">"&Z10)
U10	U10	=IFERROR(VLOOKUP(A10,TeamRankings!J3:M32,4,0),"")
AC10	AC10	=COUNTIF(L10,"<"&L9)+COUNTIF(N10,">"&N9)+COUNTIF(O10,">"&O9)+COUNTIF(Q10,">"&Q9)+COUNTIF(U10,">"&U9)+COUNTIF(V10,">"&V9)+COUNTIF(X10,">"&X9)+COUNTIF(Y10,">"&Y9)+COUNTIF(Z10,">"&Z9)

 

[jasonb75]

Try this in AC10

=SUMPRODUCT((COLUMN(L10:Z10)={12;14;15;17;21;22;24;25;26})*(L9:Z9=L10:Z10))

 

[kweaver]

What duplicates are you trying to count? The 2 33%?

 

[gtd526]

Try this in AC10

=SUMPRODUCT((COLUMN(L10:Z10)={12;14;15;17;21;22;24;25;26})*(L9:Z9=L10:Z10))

Yes, it counts 1, but I need it incorporated to the existing formula, so it counts everything.

 

[gtd526]

What duplicates are you trying to count? The 2 33%?

Yes. It needs to be in the current formula so it counts everything.

 

[jasonb75]

Yes. It needs to be in the current formula so it counts everything.

So you don't want to count duplicates, you want to count values that are either >= or <= than the corresponding cell.

Insert an = symbol after each < and > in your original formula.

 

[gtd526]

So you don't want to count duplicates, you want to count values that are either >= or <= than the corresponding cell.

Insert an = symbol after each < and > in your original formula.

Well, I added your formula to the end of my count formula, and it added 1.
Yes, <= or >=, I will add.
Thanks for the reply.