Countif - How do I count the number of job titles occurring in a l

[Guest]

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"?

 

[Guest]

Try eliminating the quotes around B1

 

[Bob Phillips]

And the =

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Oh - it's the little things isn't it? Thanks to both of you for the help