counting across a row/range

[The Grim Discovery]

Hello

How do I do this, please someone please point me in the right direction??
If a row contains a single 'NO' (like Row 1) I'd like to count that as one.
If a row contains multiple instances of 'NO' (like Row 2) I'd like that to be counted just as one.
I'm not interested in counting the instances of 'NO' just if there is at least one in a row.
The same with numbers. I'm not interested in the values of numbers just if there is at least one in a row.

Tried variations of COUNTIFS and ANDs but it's not happening for me.
Thanks in advance.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]NO[/TD]
[TD]75[/TD]
[TD]100[/TD]
[TD]250[/TD]
[TD]500[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]100[/TD]
[TD]200[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

What are the results that you want to see for row 1 and row 2?

 

[SyedUsman]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]DATA[/TD]
[TD]DATA[/TD]
[TD]DATA[/TD]
[TD]DATA[/TD]
[TD]DATA[/TD]
[TD]=NO[/TD]
[TD]=NUMBER[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]NO[/TD]
[TD]75[/TD]
[TD]100[/TD]
[TD]250[/TD]
[TD]500[/TD]
[TD]=COUNTIF(A2:E2,"No")>0[/TD]
[TD]=ISNUMBER(MAX(A2:E2))[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]100[/TD]
[TD]200[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]NO[/TD]
[TD]=COUNTIF(A3:E3,"No")>0[/TD]
[TD]=ISNUMBER(MAX(A3:E3))[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]












The Answer Will Return True if No or Numerics are available in a range

Cheers

 

[The Grim Discovery]

Hello Aladin

Reading that back again I see there's a problem

I'd like Row 1 to be the equivalent of a YES, as in, yes there is a number between A1:E1.
It's only in rows that contain at least one 'No' and no numbers that I'd want this to be counted separately as a NO.

Hope that's an improvement...

 

[The Grim Discovery]

Thanks Syed, lovely stuff.

 

[Aladin Akyurek]

Hello Aladin

Reading that back again I see there's a problem

I'd like Row 1 to be the equivalent of a YES, as in, yes there is a number between A1:E1.
It's only in rows that contain at least one 'No' and no numbers that I'd want this to be counted separately as a NO.

Hope that's an improvement...

A single formula per row could be:

=IF(COUNT(A1:E1),"YES",IF(COUNTIFS(A1:E1,"NO"),"NO","")

 

[The Grim Discovery]

Thanks Aladin. Appreciated.