View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patti Patti is offline
external usenet poster
 
Posts: 45
Default Formula Help for Counting categories in a column

Hi!
I'm a teacher and we are scheduling students. Each student is assigned for
classes. We are trying to find a way for Excel to count the number of times
the class name appears so that we can get a class size by class name. For
instance,
if ART class has 40 people with ART in the column, we'd like it to count and
put a number in cell next to the label ART. We need to know if we are over
our maximum class size. Please HELP me!
--
Thanks,
Patti