I'm trying to create a spreadsheet that will allow me to create a master formula that I can paste into cells to give me total based upon a percentage of hour and an individual person. For example say someone worked .5 hours on something, one person's rate is $250.00 dollars an hour, another person's is $175.00, and some other people are $90.00. I thought I could create a spread sheet that listed the time, then the person's initials and then get the subtotal of that hour and that person's rate all in one row. I used to be a lot better at this but I'm not sure how to create something like that.

Is there a way to create like an if then with that many people in it? Like, If C3=ABC then B3 250, if C3=XYZ, then B3 *175, if C3=DEF, then B390 all in one formula to be pasted into each individual row?

Also, Is there a way I can place a formula in a cell near the top that sums that entire column no matter what the last cell in that column is?

Finally, is there some way I can create a formula that gives the total amount of hours per person?

Thanks in advance for any guidance you can give me.