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:
HTH
Bookmarks