The Grim Discovery

Board Regular
Joined
Jan 23, 2015
Messages
232
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"})))))
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
Try...

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

Watch MrExcel Video

Forum statistics

Threads
1,109,523
Messages
5,529,333
Members
409,863
Latest member
stacy09
Top