View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Countif - How do I count the number of job titles occurring in a l

Try eliminating the quotes around B1
--
Brevity is the soul of wit.


"dsmith@organic" wrote:

Column A contains 1,000 positions. Each position falls into one of 25 titles.
the titles are in column B rows 1-25. I want to count the number of "Acct
managers" in column A by referencing the test in column B. When I enter the
formula =COUNTIF($A$1:$A$1001,"=B1") I get a return of 0. Cell B1 contains
the title (Text). Do I have to type the text in each formula - i.e.
=COUNTIF($A$1:$A$1001,"=Acct Manager") - instead of referencing the cell
"B1"..."B20"?