1 Reply Latest reply: May 15, 2014 9:51 AM by Grant Perkins RSS

    a counting question

    DZizzo _

      I have a file containing department, course, section and enrollment.  Example:

       

      ANTH 1113 001 24

      ANTH 1113 002 33

      ANTH 1113 003 29

      ANTH 1213 001 22

      ANTH 1213 002 19

      ANTH 1323 001 10

      CHEM 1113 001 37

      CHEM 1113 002 40

      CHEM 1213 001 25

       

      I can sum the enrollments for each dept and count the number of different sections by dept - no problem.  But I also need to count the number of different courses for each dept - problem.  In this case, for ANTH the count would be 3, for CHEM 2.  I hope I'm overlooking some obvious way to do this and would sure appreciate any help!  Thanks!