COUNT A YES STATEMENT AGAINST A NAME
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 |
COUNT A YES STATEMENT AGAINST A NAME
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 --------------- Jacob Skaria "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 |
COUNT A YES STATEMENT AGAINST A NAME
=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 |
COUNT A YES STATEMENT AGAINST A NAME
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 |
COUNT A YES STATEMENT AGAINST A NAME
This si great thanks
"Jacob Skaria" wrote: 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 --------------- Jacob Skaria "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 |
All times are GMT +1. The time now is 10:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com