excel count "√"

[kelvin_9]

greeting to all

wondering is there any other formula will be more effiency and be better than mine in below which i am using?
i need a formula in cell B3 to count how many "√" in range d3, f3, h3......... so on

=SUM(COUNTIF(INDIRECT({"d3","f3","h3","j3","l3","n3","p3","r3","t3","v3","x3","z3"}),"√"))

thanks for your guidance

 

[Fluff]

How about

=SUMPRODUCT((D3:Z3="√")*(MOD(COLUMN(D3:Z3),2)=0))

 

[Scott Huish]

Could that symbol appear in the alternating cells or will it just appear in those cells specifically?

 

[kelvin_9]

How about

=SUMPRODUCT((D3:Z3="√")*(MOD(COLUMN(D3:Z3),2)=0))

thank you very much for your reply, Fluff

can this apply to C3 with range e3, g3, i3.........aa3

thank you very much for your guidance

statistics 2024.xlsx
	B	C	D	E	F	G	H	I	J	K
1	COUNT (SCHEDULDED)	COUNT (ACTUAL)	1		2		3		4
2			scheulded	actual	scheulded	actual	scheulded	actual	scheulded	actual
3	4	0	√	√	√	√	√	X	√	X
NIGHT

Cell Formulas
Range	Formula
B3	B3	=SUMPRODUCT((D3:Z3="√")*(MOD(COLUMN(D3:Z3),2)=0))
C3	C3	=SUMPRODUCT((D3:Z3="x")*(MOD(COLUMN(D3:Z3),2)=0))

 

[kelvin_9]

Could that symbol appear in the alternating cells or will it just appear in those cells specifically?

thank you very much for your reply, Scott Huish

those cells only, so that i want to calculate how many "√" and "X" return in cell B3 and C3

statistics 2024.xlsx
	B	C	D	E	F	G	H	I	J	K
1	COUNT (SCHEDULDED)	COUNT (ACTUAL)	1		2		3		4
2			scheulded	actual	scheulded	actual	scheulded	actual	scheulded	actual
3			√	√	√	√	√	X	√	X
NIGHT

 

[Fluff]

How about

=SUMPRODUCT((D3:Z3="√")*(MOD(COLUMN(D3:Z3),2)=1))

 

[Scott Huish]

I fixed the spelling of scheduled, but perhaps:
=SUMPRODUCT(--(D3:Z3="√"),--(D2:Z2="scheduled"))

 

[kelvin_9]

How about

=SUMPRODUCT((D3:Z3="√")*(MOD(COLUMN(D3:Z3),2)=1))

thank you very much for your reply, Fluff

both formula are working fine

thank you very much for your guidance

 

[kelvin_9]

I fixed the spelling of scheduled, but perhaps:
=SUMPRODUCT(--(D3:Z3="√"),--(D2:Z2="scheduled"))

thank you very much for your reply, Scott Huish

xdxdddd, the spelling
this is perfect

thank you very much for your guidance

 

[Fluff]

Glad we could help & thanks for the feedback.