I am trying to create a sheet that will take a list of data that and generate a schedule by using employee names. I also would like the same sheet to be able to calculate daily payroll.Scheduling Labor guidelines (safe).xls

Is there a way to assign each name with a dollar amount, then use a sum() command to add the names for the given hours worked? Or perhaps someone has an easier way to work this problem. I don't have much experience using tables/lists or much knowledge of exactly how the if() statements work so any help would be greatly appreciated.