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
gwarcherAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
ProfessorJimJamConnect With a Mentor Commented:
put this in your new column and copy down

=SUMIFS($C$2:$C$10,$A$2:$A$10,$A2)
0
 
ProfessorJimJamCommented:
see attached file
Book1.xlsx
0
 
gwarcherAuthor Commented:
Perfect thanks!
0
All Courses

From novice to tech pro — start learning today.