Hi

I have this excel file with students name, unique id and their courses and
number of units for each course. Some students are taking one class and some
more than one. Classes are of different number of units, some classes are 3
units, some are 4 and some are 5. I need to bill these students based on
number of units they are taking each semester. How can i get a total number
of units for each student in this table.

Thanks





First Name Last Name Student Id Program Course Units Cost/Unit
John LEE ww5545 ADP MGMT 4 201.00
Jacob Welsh xd4457 ADP ENGR 3 201.00
James Martinez cd4785 MBA ITM7 4 185.00
James Schultz fd7485 Exchange ANTH01 4 201.00
CRJA01 4 201.00
ENVT02 4 201.00
John Hopkins rf7898 Exchange COMM02 4 201.00
ENGLHA 4 145.00
ENGLHA 4 145.00
Mary Aileen fd8547 Exchange PUAD01 4 224.00
PUAD01 4 224.00
John Winnet gg7485 MBA ITM7HA 4 185.00