calculate with symbol "√"

[kelvin_9]

greeting to all

how could i amend my formula to calculate with "√" at U54?
ps: my expected answer would be 18
also, can i return blank cell instead of 0 at U54 or U62?

thanks for the guidance

NEW 1.3_v2.xlsx
	K	L			O						U
54	√	√			20						20
55
56
57
58
59
60
61
62		√									0
63	√
64	√
65
66
67
68
69
176 - Disney Explorers Lodge

Cell Formulas
Range	Formula
O54	O54	=IFERROR(H54-COUNTIF(K54:K61,"><")+COUNTIF(L54:L61,"<>"),"")
U54	U54	=IFERROR(SUM(O54:O61-SUM(K62:K69)),"")
U62	U62	=IFERROR(SUM(O62:O69-SUM(K70:K93)),"")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K54:L85	Expression	=E54="√"	text	NO
U54:U77	Cell Value	between 10 and 1	text	NO
U54:U77	Cell Value	between -1 and -20	text	NO

Cells with Data Validation
Cell	Allow	Criteria
K54:L69	List	√

 

[Peter_SSs]

Does this do what you want?

23 08 29.xlsm
	K	L			O						U
54	√	√			20						18
55
56
57
58
59
60
61
62		√
63	√
64	√
65
66
67
68
69
Sheet2 (3)

Cell Formulas
Range	Formula
U54	U54	=IFERROR(O54-COUNTIF(K62:K69,"<>"),"")

 

[kelvin_9]

Does this do what you want?

23 08 29.xlsm
	K	L			O						U
54	√	√			20						18
55
56
57
58
59
60
61
62		√
63	√
64	√
65
66
67
68
69
Sheet2 (3)

Cell Formulas
Range	Formula
U54	U54	=IFERROR(O54-COUNTIF(K62:K69,"<>"),"")

thank you very much for your reply, Peter_SSs

work exactly what i want

thank you

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.