How to Sum
assume allred, C. is in a1
in D1 put in the formula
=sumif(A:A,A1,B:B)
then drag fill down column D as far as necessary.
--
Regards,
Tom Ogilvy
"Tia" wrote:
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.
|