gwarcher
asked on
Excel function - Sum 3 numbers based on info on two separate columns
I have an excel sheet that looks like this
Name Type Total NEWCOLUMN
Smith A 5 35
Smith B 7 35
Smith C 23 35
Johnson A 76 144
Johnson B 45 144
Johnson C 9 144
Robertson A 65 148
Robertson B 32 148
Robertson C 51 148
I need to SUM the Totals together (A B and C) based on the changing name, I don't care if the sum goes into each row. (See NEWCOLUMN) I just don't know if I could do this in a function or if I need VBA.
THanks
Name Type Total NEWCOLUMN
Smith A 5 35
Smith B 7 35
Smith C 23 35
Johnson A 76 144
Johnson B 45 144
Johnson C 9 144
Robertson A 65 148
Robertson B 32 148
Robertson C 51 148
I need to SUM the Totals together (A B and C) based on the changing name, I don't care if the sum goes into each row. (See NEWCOLUMN) I just don't know if I could do this in a function or if I need VBA.
THanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect thanks!
Book1.xlsx