statistics of text

hoz

New Member
Joined
Apr 8, 2002
Messages
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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,185
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top