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