Count depending on instance?

[David Kemp]

[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]Tony
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Tony
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Frank
[/TD]
[TD]No
[/TD]
[/TR]
[TR]
[TD]Frank
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Frank
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Tony
[/TD]
[TD]No
[/TD]
[/TR]
[TR]
[TD]Tony
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]Kate
[/TD]
[TD]No
[/TD]
[/TR]
[TR]
[TD]Kate
[/TD]
[TD]No
[/TD]
[/TR]
</tbody>[/TABLE]

Hi everyone,

I want to count how many times yes has occurred once for each person. For example, Tony has 3 yes's, Frank has 2, Kate none.

I want another cell to count them and return a value of 2, one for all of Tony's yes's, and one for all of Frank's.

This is just a basic mock up, the real deal will have hundreds of names. Any suggestions?

 

[dispelthemyth]

Thanks for the feedback, i'd probably agree with you but i need to look into the frequency formula as i see it used for a few complex formulas, but i dont grasp how it works yet, ,maybe ill review it on the train later on

@dispelthemyth

Frequency for unique count is faster than Hager's SUM/COUNTIF idiom. Also, I believe a global distinct count is asked for...

 

[Aladin Akyurek]

Thanks for the feedback, i'd probably agree with you but i need to look into the frequency formula as i see it used for a few complex formulas, but i dont grasp how it works yet, ,maybe ill review it on the train later on

http://www.mrexcel.com/forum/excel-...ing-sum-if-frequency-match-2.html#post3156949

This one discusses the Hager's...

http://www.mrexcel.com/forum/excel-questions/70835-count-distinct-function.html#post342159

Performance question:

http://www.mrexcel.com/forum/excel-questions/292473-performance-formulas-unique-count.html

 

[dispelthemyth]

Thanks for the links, some very interesting reading

Appreciate it

http://www.mrexcel.com/forum/excel-...ing-sum-if-frequency-match-2.html#post3156949

This one discusses the Hager's...

http://www.mrexcel.com/forum/excel-questions/70835-count-distinct-function.html#post342159

Performance question:

http://www.mrexcel.com/forum/excel-questions/292473-performance-formulas-unique-count.html

 

[Aladin Akyurek]

Thanks for the links, some very interesting reading

Appreciate it

Thanks for the feedback.