The Grim Discovery
Board Regular
- Joined
- Jan 23, 2015
- Messages
- 244
- Office Version
- 365
- Platform
- Windows
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"})))))
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"})))))