View Single Post
  #3   Report Post  
Bill Ridgeway
 
Posts: n/a
Default

A Pivot table should do that job OK.

Click on <Data<Pivot table and pivot chart report. Follow the prompts and
drag the column headings to the 'table'. You may have to experiment a bit
but once you've got the hang of pivot tables they are quite straight
forward.

Regards.

Bill Ridgeway
Computer Solutions

"VP" wrote in message
...
I have a spreadsheet with one column of employee's job titles. One of the
other columns shows if they work full time or part time. There are
several
employees with the same title who work either full time or part time. I
need
a formula which calculates how many employees with that title work full
time
and how many with that title work part time. (sorry if this is a
duplication
- it didn't look like my first attempt to send worked.)