Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count if statement | Excel Worksheet Functions | |||
If & Count Statement | Excel Worksheet Functions | |||
Count If Statement Using Dates | Excel Discussion (Misc queries) | |||
Help with Count IF Statement | Excel Discussion (Misc queries) | |||
count if statement | Excel Discussion (Misc queries) |