View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Angyl Angyl is offline
external usenet poster
 
Posts: 15
Default Best way to total scattered data?

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?