In Column A I have a list of dates. When somebody uses FMLA I will enter the hours used into Column C. I need excel to search for the max date with a value in C and give me the total which will be in in Column E of the same row.

Example:
A B C D E
1/2/2008 FMLA 8 DS 8

1/4/2008 FMLA 1 XEND 9

1/6/2008 FMLA 3 DS 12