Formula to convert textual number values array to actual number values

[Preacherman771]

I am trying to count the number of each group of duplicate values in column O25:O40 using COUNTIF($O$25:$O$40,"0.688"). Knowing that the values in that column are textual and not actual numeric values, how would I go about changing them to numeric as part of my formula. Or, do I need to first create a helper column? Any help is greatly appreciated.

NFL 2021-2022 Standings (Template).xlsx
	H	I	J	K	L	M	N	O
23
24	Rnd 1			Team		Team		Pct
25			1	KC		---
26			2	BUF		---
27			3	PIT		---
28			--	TBD		BAL		0.688
29			--	TBD		CLE		0.688
30			--	TBD		IND		0.688
31			--	TBD		TEN		0.688
32			8	MIA		---
33			9	LV		---
34			--	TBD		NE		0.438
35			--	TBD		LAC		0.438
36			12	DEN		---
37			13	CIN		---
38			14	HOU		---
39			15	NYJ		---
40			16	JAX		---
Calc_Ties (Conf)

Cell Formulas
Range	Formula
J25:J40	J25	=IFERROR(INDEX($H$7:$H$22,MATCH(K25,$I$7:$I$22,0)),"--")
K25:K40	K25	=IF(AND(K7=K8,OR(ROWS(K$25:K25)*COLUMNS(K$25:K25)=1,ROWS(K$25:K25)*COLUMNS(K$25:K25)=16)),"TBD", IF(OR(K6=K7,K7=K8),"TBD",I7))
M25:M40	M25	=IF(K25<>"TBD","---",I7)
O25:O40	O25	=IF(M25<>"---",INDEX($K$7:$K$22,MATCH(M25,$I$7:$I$22,0)),"")

 

[Fluff]

How about

=IF(M25<>"---",INDEX($K$7:$K$22,MATCH(M25,$I$7:$I$22,0)+0),"")

 

[Preacherman771]

Thanks, but when I entered COUNTIF($O$25:$O$40,"0.688") after changing the formula in column O25:O40 to your suggested formula, I receive a result of 0 and not the number of times 0.688 appears. Any other suggestions?

 

[Fluff]

That would suggest that you numbers don't exactly = 0.688
If your current formulae work, why not leave it as-is.

 

[Preacherman771]

The original COUNTIF did not work either with my current formula, thus the request for the ability to convert over within the same formula. Or is the only recourse I have is to create a helper column which incorporates the cells using NUMBERVALUE?

 

[Fluff]

You could round the values like

=IF(M25<>"---",ROUND(INDEX($K$7:$K$22,MATCH(M25,$I$7:$I$22,0))+0,3),"")

 

[Preacherman771]

Thank you for you responses and suggestions.

 

[Fluff]

Glad to help & thanks for the feedback.