I have two colums one contains yes no and some are just blanks. The other is a list of names. I want to count the blanks in b and have it compare to a certain name in A. I can't quiet figure out the formula todo this.


A B
Jose Yes
Joe Yes
Jose
carl No
Randy
Jose No
carl No
Robin
mary Yes
Robin Yes
Mary
carl
Jose Yes
mary
Jose Yes
Robin
mary Yes