# VLOOKUP and a COUNTIF?

#### kristalauren

##### New Member
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".

 Names date raised idea details idea viable Status Ally 01/01/14 blah Yes Complete Steve 01/01/14 blah Yes In progress Ally 01/01/14 blah No Complete Steve 01/01/14 blah Yes Complete

<tbody>
</tbody>

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

#### Caribeiro77

##### Well-known Member
Maybe:
=COUNTIFS(\$A\$2:\$A\$5,"Ally",\$D\$2:\$D\$5,"Yes")

#### kristalauren

##### New Member
Maybe:
=COUNTIFS(\$A\$2:\$A\$5,"Ally",\$D\$2:\$D\$5,"Yes")

Thanks!
Worked perfectly.

Replies
0
Views
711
Replies
3
Views
392
Replies
3
Views
695
Replies
3
Views
293
Replies
5
Views
1K

1,195,712
Messages
6,011,266
Members
441,598
Latest member
chrispaulpearce

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back