COUNT A YES STATEMENT AGAINST A NAME

[Dave]

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

 

[Jacob Skaria]

Suppose you have the 5000 names in Sheet2 Name in ColA and Yes/No in ColB

In sheet1 you have the 5 names in A1:A5. In B1 enter the below formula and
copy that down to A5

A1 = name1
In B1
=SUMPRODUCT(--(Sheet2!$A$1:$A$5000=A1),--(Sheet2!$B$1:$B$5000="Yes"))

If this post helps click Yes

 

[Ethoros]

=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]

This is great thanks

=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]

This si great thanks

Suppose you have the 5000 names in Sheet2 Name in ColA and Yes/No in ColB

In sheet1 you have the 5 names in A1:A5. In B1 enter the below formula and
copy that down to A5

A1 = name1
In B1
=SUMPRODUCT(--(Sheet2!$A$1:$A$5000=A1),--(Sheet2!$B$1:$B$5000="Yes"))

If this post helps click Yes