VLOOKUP and a COUNTIF?

[kristalauren]

Hi all,

I have a fairly straightforward table... similar to below but with a few more columns...
Focus here is on the NAMES and IDEA VIABLE columns.

I have set up stats on another page to count ideas raised by person using the =countif(column of names, name in cell reference)... this returns that ally has 2 x ideas, steve has 2 x ideas.
I'm now wondering if its possible to count number of viable / yes ideas per person.

The real spreadsheet is counting ideas for 50 people and ideas is currently up around 32 (new project).
Would like to graph who has the highest number of viable ideas.

I thought a Vlookup might work, but this doesnt count the number of ideas, simply returns the first value for the name (Yes or No).
Is there a formula to combine the vlookup and the countif?

Eg - if column A = Ally, count "yes".

Thanks in advance!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Names[/TD]
[TD]date raised[/TD]
[TD]idea details[/TD]
[TD]idea viable[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Ally[/TD]
[TD]01/01/14[/TD]
[TD]blah[/TD]
[TD]Yes[/TD]
[TD]Complete[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]01/01/14[/TD]
[TD]blah[/TD]
[TD]Yes[/TD]
[TD]In progress[/TD]
[/TR]
[TR]
[TD]Ally[/TD]
[TD]01/01/14[/TD]
[TD]blah[/TD]
[TD]No[/TD]
[TD]Complete[/TD]
[/TR]
[TR]
[TD]Steve[/TD]
[TD]01/01/14[/TD]
[TD]blah[/TD]
[TD]Yes[/TD]
[TD]Complete[/TD]
[/TR]
</tbody>[/TABLE]

 

[Caribeiro77]

Maybe:
=COUNTIFS($A$2:$A$5,"Ally",$D$2:$D$5,"Yes")

 

[kristalauren]

Maybe:
=COUNTIFS($A$2:$A$5,"Ally",$D$2:$D$5,"Yes")

Thanks!
Worked perfectly.