Excel spread sheet Multiple look ups
 

I am trying to pull values from one field and asign them a code and then have
these values auto sum to assigned cells.
I am using a vlook up argument to take these values and place them on a
timesheet.

Now I am trying to take these individual codes and values totaled and placed
in a summary at the bottom of the sheet.
ie p = 7.6
N= 8
S= 7.6

Total Hours
Details Hours
N Normal 64
Annual
S Sick 7.6
Lieu
Public Holiday 7.6
Other
Total Hours 0
Any suggestions would be appreciated.

Clay