I am a teacher so I am trying to create a course listing where cells contain
choices of the classes students can take during that time frame. At the
bottom of all the choices I have a total credit coloumn where I would like
the cumulated totals to be.

I need to assign course credits to the choices ie.. english is worth one
credit. How can I go about doing this? the purpose is to have the credits
column at the bottom to automatically keep track of course credits as the
student selects them.

Any Ideas?