sara wrote:
I uploaded a sample copy of my worksheet (Thanks Franz for the tip).
It can be viewed at the following site:
http://www.savefile.com/files/8768680 . Any help would be greatly
appreciated.

As you click on each drop down list for choices....each course is
worth 0.5,
1.0, or 3.0 credits. So I am trying to assign the value to each cell.

Towards the bottom of the worksheet there is a column for total
credits. here I would like the credits to add automatically. I know
how to do the sumfunctions. It is assigning the value to each text
cell that I am encountering problems. Thanks in advance for your
assistance.

"sara" wrote:

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?

Hi Sara,

sorry for answering so late.

As RagDyeR suggested, you have to split your A column to separate course
category from credit. Then you can use SUMIF or also SUMPRODUCT to summarize
credits.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy