counting based on another criteria

  • Thread starter Thread starter Christine Wilso
  • Start date Start date
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
 
Hi
and what do you want to count?. You may have a look at the
COUNTIF function or SUMPRODUCT.
 
Hi!

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

Al
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare data in 2 columns for unique values 2
Separate Variable Range of Data into Different Worksheets 4
macro to unhide a sheet 1
Good Source for Laptop Batterys 8
include criteria to 'rank based array function' 2
Check previous record when promote 2
Listing Data with Certain Qualifications 6
Calculating time in Access based on an 8 hour day 2

Back
Top