Count multiple instances within multiple row

[qwzky]

Hi! I am having some trouble with counting a certain value ("<5") within multiple rows as one, no matter how many times that value repeats itself:

SC-uri automate REDONE4 (test, ă văd dacă merge să lucrez in sheets separate).xlsm
	B	C	D	E	F	G	H	I
3	Students	Grade 1	Grade 2	Grade 3	Grade 4	Grade 5	GRADE 6	COUNT
4
5	Mark	4	4	7	7	5	5	count as 1, even if there are two "4"s (aka <=5)
6	John	6	6	6	7	6	6	don't count
7	Anne	abs	5	6	5	4	4	don't count, because there is at least 1 "abs"
8	James	10	10	10	10	9	5	don't count
9								the final result should be 2 (2 students failed)
CIORNĂ

The formula I tried is

=COUNTIF(C5:H8;"<5")

, but it returns 4 students failed. Please, help me make with this.

 

[qwzky]

I believe you Maybe, if I don't find that one formula for all my requirements, I will do that. Check here the different thread I made, with clearer description.

 

[jasonb75]

Maybe, if I don't find that one formula for all my requirements, I will do that.

I would do it anyway, although it is possible, a single formula for what you want to do is a ludicrous idea.