Quote Originally Posted by Sambo kid View Post
I'm having trouble understanding your request. You don't need a countif for one cell. You could use an if statement for that. Something like
=IF(AD1085="all of the above",1,IF(OR(AK1085=4,AK1085=5,AK1085=6),1,""))
This seems to work. Thank you!