Tired of having 259 "IF" functions nested in a single cell

Hello all... I need some help. I have a tracking sheet for company required training that is completely cumbersome to say the least. I have attached a small sheet for ya'll to play with but here is the basic concept.

The company has 259 employees that I need to track. There are 23 separate classes in the company, not all employees need all classes. Some of the classes are the same length in training hours but most are not. Right now the way the bosses want things set up is a "0" means they have completed the class. A "1" means they need the class and a blank means they don't need it at all.

Is there a way to set up a formula or logic function for column "D" so that any time I enter a "1" it will equal 2 for adding into the total count at the bottom and for column "E" so that any time I enter a "1" it will equal 16 for adding into the total count at the bottom and so on without having 259 "IF(D2=1,2,0)+IF(D3=1,2,0)……." and "IF(E2=1,16,0)+IF(E3,1,16,0).........." and so on functions in each cell across the bottom row.

The sheet is working right now but if I need to add a new employee or take out someone or even sort A>Z it just screws things up.

HELP PLEASE!!!!!!!

I also really like the SUMPRODUCT as well. Thank You

Thank you. I can't believe that something so simple was staring me in the face but I got so wrapped up trying to fix the sheet from the first person that I never even thought to go with a simple SUM.

I feel really stupid but THANK YOU!!!!!!

And for the formulas in I2:I9
=SUMPRODUCT(D2:H2,MID(SUBSTITUTE($D$1:$H$1,"hrs)",""),10,3)+0)

This would be even easier if you added a row to put the number of hours for the class (without any text in it)
Say
D25:H25 = 2 16 6 24 5

Then it's just
=SUMPRODUCT(D2:H2,D$25:H$25)