Countif not working

[ivankesaulya]

Hello all,

I need a favor from you guys.
I used countif formula to count how many cells that are larger than the other cell ..

I used ..
=countif(K:Q;">H")

But it's not working ..
Any pointers that i can use.

Thank you.
Ivan

 

[Toadstool]

Hi ivankesaulya,

It's not clear where the result should go or which cells to look at so I'll assume if any row of K through Q is greater than the single row of Target AR for that row.

ivankesaulya.xlsx
	H	I	J	K	L	M	N	O	P	Q	R	S	T
3	Target	Winning
4	AR	AR	0110	0210	0310	0410	0510	0610	0710	0810	0910	1010	1110
5
6	25%	0	12.4%	11.7%	14.0%	14.1%	15.0%	10.9%	0.0%	0.0%	0.0%	0.0%	0.0%
7	15%	3	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	16.2%	9.3%	3.3%	4.4%	14.5%
8	23%	0	0.0%	0.0%	0.0%	0.0%	0.0%	16.2%	9.3%	3.3%	4.4%	14.5%	3.3%
9	13%	7	1.0%	14.5%	0.0%	0.0%	0.0%	0.0%	0.0%	16.2%	9.3%	3.3%	4.4%
Sheet1

Cell Formulas
Range	Formula
I6:I9	I6	=COUNTIF(K:Q,">"&H6)

 

[ivankesaulya]

Hi ivankesaulya,

It's not clear where the result should go or which cells to look at so I'll assume if any row of K through Q is greater than the single row of Target AR for that row.

ivankesaulya.xlsx
	H	I	J	K	L	M	N	O	P	Q	R	S	T
3	Target	Winning
4	AR	AR	0110	0210	0310	0410	0510	0610	0710	0810	0910	1010	1110
5
6	25%	0	12.4%	11.7%	14.0%	14.1%	15.0%	10.9%	0.0%	0.0%	0.0%	0.0%	0.0%
7	15%	3	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	16.2%	9.3%	3.3%	4.4%	14.5%
8	23%	0	0.0%	0.0%	0.0%	0.0%	0.0%	16.2%	9.3%	3.3%	4.4%	14.5%	3.3%
9	13%	7	1.0%	14.5%	0.0%	0.0%	0.0%	0.0%	0.0%	16.2%	9.3%	3.3%	4.4%
Sheet1

Cell Formulas
Range	Formula
I6:I9	I6	=COUNTIF(K:Q,">"&H6)

Yesssss ..

Thank you so much ..
Works like a charm ..

God Bless You my friend

Regards,
Ivan

 

[Toadstool]

You're welcome.