=sumproduct((a$1:$a$100="name")*($b$1:$b$100="yes"))