counting based on another criteria

C

Christine Wilso

I have two columns, one contains a list of job titles the other a lis
of responses to a question:
A B
Clerk
Clerk
Analyst
Clerk
Analyst
Enginee
 
F

Frank Kabel

Hi
and what do you want to count?. You may have a look at the
COUNTIF function or SUMPRODUCT.
 
A

AlfD

Hi!

Use a Pivot table. But be careful that your field names and categorie
are carefully spelled :)

Al
 
Top