Countif Counting Drop Down List Of Names

Hello,

I am hoping that this is an easy fix

I am trying to count a group of cells that are populated by a drop down list of names of my employees.

When the user selects the name in a cell on the right it counts that names as 1

the formula I have is
=COUNTIF(B13:B36,"<joe,james,angela,elysse,dana,monica,kim,ariel,jd,pankou,vanessa,michelle>")

Now it counts most of the names as 1 in the right cell. but it does not count Monica,Kim,Pankou,Vanessa,Michelle. It does count JD as 1 and the rest of the associates but I cannot figure out what I am missing here.

I am trying to understand excel and formula's but I think i need a fresh pair of eyes on this.

Any help would be appreciated.

thanks
Joe

Originally Posted by rocole924

Hello,

I am hoping that this is an easy fix

I am trying to count a group of cells that are populated by a drop down list of names of my employees.

When the user selects the name in a cell on the right it counts that names as 1

the formula I have is
=COUNTIF(B13:B36,"<joe,james,angela,elysse,dana,monica,kim,ariel,jd,pankou,vanessa,michelle>")

Now it counts most of the names as 1 in the right cell. but it does not count Monica,Kim,Pankou,Vanessa,Michelle. It does count JD as 1 and the rest of the associates but I cannot figure out what I am missing here.

I am trying to understand excel and formula's but I think i need a fresh pair of eyes on this.

Any help would be appreciated.

thanks
Joe

Assuming I've understood your problem, it's the cell reference that contains your dropdown list that should be the object of your COUNTIF() function. So assuming the dropdown is cell D1 our formula would be:

Please Login or Register  to view this content.

HTH

Hello Richard,

I am enclosing the form I am working with, as you can see in AE22 I have the formula mentioned. When a name is picked under the drop down list in the associates name section it counts that person as 1 (example: Joe in AE22 is 1) but it will not do it for all the names I have in the formula or that are listed in the drop down.

The cell actually skips certain people at random???

Hope that clarify's it a little.

Thanks for responding and the help, I just joined today because a friend told me about this site and I have found several things useful.

Joe





Daily Demo.zip

Your formula counts alphabetically anyone who is less than the string

joe,james,angela,elysse,dana,mo nica,kim,ariel,jd,pankou,vanessa,michelle>

ie nearer the front of the alphabet

as you have highligthed it does not count
Monica,Kim,Pankou,Vanessa,Michelle as these names are later that the string alphabetically

perhaps

=COUNTA(B13:B36)

Is that what you require?

Regards

Dav