I've got a table that has multiple columns. We are using it to calculate
payroll....It looks like the following....
Pay Period 1
A B C
Allred, C. 1500.00 25.45
Hills, J. 1750.00 25.45
Smith, J. 1500.00 25.45

Pay Period 2
Allred, C. 1500.00 25.45
Hills, J. 1750.00 25.45
Smith, J. 1500.00 25.45

I need a formula that looks at Column A, when it says "Allred, C." it then
calculates column B so that I have a total for both pay periods. I'm at a
loss as to what the formula should look like....

Any help would be appreciated.