I have a worksheet in which I want to be able to give the NO's in the drop
down a different value so that the total value when added up will tell me the
number of guided learning hours required for the individual.

I hope this makes sense..