Case IF, count if

[Sefty]

Hello,
I need help, why is this formula an error?
What should the formula be like?
Thanks

Keterkaitan Struktur AP Transformasi Sosial _Mengikuti Hotel_ (2).xlsx
	A	B	C	D	E	F	G	H	I											T	U	V	W	X
1																				Kriteria Wajib	KP Transformatif
2	aha	Kode	X	X	X	X	X	X	X											X	X	X	X	X
20	KP	01.01.01	X	X	X	X	X	X	X											v		v		#VALUE!
21	KP				X	X	X	X	X											v		v		0
22	KP				X	X	X	X	X											v		v		0
23	KP				X	X	X	X	X											v		v		0
24	KP				X	X	X	X	X											v		v		0
25	KP				X	X	X	X	X											v		v		0
26	KP				X	X	X	X	X											v		v		0
27	KP				X	X	X	X	X											v		v		0
28	KP				X	X	X	X	X											v		v		0
29	KP				X	X	X	X	X											v		v		0
30	KP				X	X	X	X	X											v		v		0
55	KP	01.01.02	X	X	X	X	X	X	X											v	v			#VALUE!
56	KP				X	X	X	X	X											v	v			0
57	KP				X	X	X	X	X											v	v			0
58	KP				X	X	X	X	X											v	v			0
59	KP				X	X	X	X	X											v	v			0
75	KP	01.01.03	X	X	X	X	X	X	X											v			v	#VALUE!
76	KP				X	X	X	X	X											v			v	0
77	KP				X	X	X	X	X											v			v	0
78	KP				X	X	X	X	X											v			v	0
79	KP				X	X	X	X	X											v			v	0
80	KP				X	X	X	X	X											v			v	0
Form ceklis

Cell Formulas
Range	Formula
X75:X80,X55:X59,X20:X30	X20	=IF(AND(A20="KP", NOT(ISBLANK(B20))), IF(SUM(IF(U20:W20="v",1,0))>1, 1, 0), 0)

 

[SunnyAlv]

I don't know what achievement you want I see that you want to display the number "1" if A20 and B20 contain values, so is this formula correct?

=IF(AND(A20="KP", NOT(ISBLANK(B20))=TRUE), IF(COUNTIF(U20:W20,"v")>0, 1, 0), 0)

 

[Scott Huish]

Does this do what you want?

=(A20="KP")*(B20<>"")*(COUNTIF(U20:W20,"v")>0)