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

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

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

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

And the =

--
HTH

Bob Phillips

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

"Dave F" wrote in message
...
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"?

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

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

"Bob Phillips" wrote:

And the =

--
HTH

Bob Phillips

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

"Dave F" wrote in message
...
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"?