Isblank fail

[The Grim Discovery]

People

Please glance over my formula below (which BTW I've placed in Cell E10).

As you'll see I'm counting the number of 'yes' in E6:E9 and counting the number of 'yes' and 'no' in the same range. I've bolted on the start of the formula the bits I thought would ensure Cell E10 would appear blank if E6:E9 were all not populated. It's not working. I cant see why. Please help. Thanks.


=IF(AND(ISBLANK(E6),(ISBLANK(E7),ISBLANK(E8),(ISBLANK(E9),"",COUNTIF(E6:E9,"yes") &"/" &SUM(COUNTIF(E6:E9,{"YES";"NO"})))))

 

[Aladin Akyurek]

Try...

=IF(COUNTIF(E6:E9,"?*"),COUNTIF(E6:E9,"yes") &"/" &SUM(COUNTIF(E6:E9,{"YES";"NO"})),"")

 

[The Grim Discovery]

Aladin - that's nailed it. Brilliant. And it's not for the first time I say thanks for helping me out.

 

[Aladin Akyurek]

Aladin - that's nailed it. Brilliant. And it's not for the first time I say thanks for helping me out.

Great. Glad to help.

 

[CA_Punit]

What is the use of "?". @Aladin Akyurek

Thanks for Helping sir

 

[Aladin Akyurek]

What is the use of "?". @Aladin Akyurek

Thanks for Helping sir

? stands for a text character; ?* one or more characters...