This is great thanks

"Ethoros" wrote:

=SUMPRODUCT((A1:A11="Name")*(B1:B11="Yes")*1)

Change the ranges as needed. Ranges must be equal on both criteria and you
can't just use columns

"Dave" wrote:

Hi, I have sheet with a list of 5 names in and another sheet with the same
names (about 5000) in total and yes or no recorded against each of these
names.

How do I count from the how many times yes is against a particular name?

Thanks