A pivot table will do a very nice job for you. They are very powerful once you
get to know them.

Take a look at Chip Pearson's site for a tutorial on them:
http://www.cpearson.com/excel/pivots.htm

--
Regards,
Fred


"VP" wrote in message
...
I have a spreadsheet listing employees jobs in one column. Another column
lists if they are full time or part time. There are several employees with
the same job but work different times. I need a formula to calculate how
many people with that title work full time and how many people with the same
job work part time.