Sort the data by Counselor and then do the following

Click DATA in the menu and select SUBTOTALS

In the dialog box, set the following values:

AT EACH CHANGE IN set to Counselor
USE FUNCTION set to Count
Click the Check box for the Client Name field as the item to count
Click OK to generate subtotals.

The count per counselor appears after each name grouping and an overall
count of client names appears on the last line of the subtotals.
--
Kevin Backmann


"Angyl" wrote:

I've got a worksheet that I need to grab total numbers off of but I don't
know how to separate them out the way the sheet is currently set up. Right
now it looks something like:

Client Name: Signup Date: Counselor
Janet 10-24-07 Mike
Bill 10-24-07 Mike
Evan 10-26-07 Steve
Lucy 10-27-07 Alice

Is it possible for Excel to gather the fact that MIKE has 2 enrollments and
STEVE and ALICE each have 1?