statistics of text

hoz · Apr 9th, 2002, 06:02 AM

I have two columns. One column contains the names of the people working in an organization. The second column contains the people's functions within the org:

NAME-----------JOB
Joe-----------Analyst
Jim-----------Manager
Mary----------Secretary
Jackie--------Manager
Christie------Analyst

What I want to achieve is the following:
Analysts:---2
Managers:---2
Secretary:--1

Which function or formula do I need to use in order to be able to count how many manager, analyst, and secretary are in the JOB column. Can someone help me out?

Thanks a lot

[ This Message was edited by: hoz on 2002-04-09 05:04 ]

Andrew70 · Apr 9th, 2002, 06:13 AM

=COUNTIF(C1:C10,"Analyst")

Dave Hawley · Apr 9th, 2002, 06:17 AM

Hi

A simple Pivot table would be ideal for this.

eliW · Apr 9th, 2002, 06:20 AM

Hi hoz,
You can use from menu Data|Subtotals
on column "Job" and you'll get what you want.
Eli

[ This Message was edited by: eliW on 2002-04-09 05:21 ]

hoz · Apr 9th, 2002, 08:29 AM

THANK YOU for all ur help.

What works best is the countif function. I tried the COUNT, DCOUNT, COUNTA, and DCOUNTA functions but to no avail.
The COUNTIF function is perfect...thanks for all your help

hoz

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 06:02 AM	#1
hoz New Member Join Date: Apr 2002 Posts: 2	I have two columns. One column contains the names of the people working in an organization. The second column contains the people's functions within the org: NAME-----------JOB Joe-----------Analyst Jim-----------Manager Mary----------Secretary Jackie--------Manager Christie------Analyst What I want to achieve is the following: Analysts:---2 Managers:---2 Secretary:--1 Which function or formula do I need to use in order to be able to count how many manager, analyst, and secretary are in the JOB column. Can someone help me out? Thanks a lot [ This Message was edited by: hoz on 2002-04-09 05:04 ]

Apr 9th, 2002, 06:13 AM	#2
Andrew70 New Member Join Date: Apr 2002 Posts: 30	=COUNTIF(C1:C10,"Analyst")

Apr 9th, 2002, 06:17 AM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi A simple Pivot table would be ideal for this.

Apr 9th, 2002, 06:20 AM	#4
eliW Board Regular Join Date: Mar 2002 Posts: 1,805	Hi hoz, You can use from menu Data\|Subtotals on column "Job" and you'll get what you want. Eli [ This Message was edited by: eliW on 2002-04-09 05:21 ]

Apr 9th, 2002, 08:29 AM	#5
hoz New Member Join Date: Apr 2002 Posts: 2	THANK YOU for all ur help. What works best is the countif function. I tried the COUNT, DCOUNT, COUNTA, and DCOUNTA functions but to no avail. The COUNTIF function is perfect...thanks for all your help hoz