# Count Filled Names

#### jcda2912

##### New Member
I really appreciate if anyone can help me with the following:

Column A: Column B:
JANE DOE Jane
JANE DOE ------
JANE DOE Karla
JANE DOE Mike
JOHN DOE jane
JOHN DOE Jane
JOHN DOE ------
JOHN DOE -----
JOHN DOE ------

As you can see above Jane Doe has 3 names in column B, as John Doe has 2.

I need a formula which measures jane doe and how many filled names it has in column B. The same for John Doe.

THank you

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### schielrn

##### Well-known Member
Maybe try:

=sumproduct(--(A1:A100="Jane Doe"),--(B1:B100<>"")

This is assuming the cells are blank and not ------.

Hope that helps.

#### SteveO59L

##### Well-known Member
Try a Pivot table

Excellent. Done.

Thanks

Replies
3
Views
146
Replies
1
Views
328
Replies
3
Views
132
Replies
1
Views
175
Replies
2
Views
175

1,190,614
Messages
5,981,944
Members
439,745
Latest member
thepasmiths

### 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