How to add hours based on different cell items/ headers? + NEW QUESTION

[Christene]

Hello,

This is my first post. Please forgive my unknowing. I am trying to create a spreadsheet that will add hours value based on a text cell header that includes different items. I need to to tally the hours for the different items as they are entered by various users. Example:

Admin/ Jamie/ 3
Phone Meeting/ Tin/ 1
Video Planning/ Charlie/ 2
Recruiting/ Charlie/ 2
Planning & Management/ Tin/ 1
Admin/ Tin/ 1
Phone Meeting/ Alex/ 1

I have attached a sample of what I have so far...

Screen shot 2012-04-02 at 10.33.41 AM.jpg

Thanks so much for any help/ tips/ guidance!
Christene