How to total quantity based on similar name in column
I am trying to total points based on the persons name. Basically one column has the names, some of them duplicates. Another Column has points. I need a third column for total points at the end that looks at the names, finds those that are the same and totals the points for that person in the total points column. I have done this in excel
Column B is the name
Column C is the points
This formula is in the total points column.
I tried doing this in excel and then uploading to smartsheets but I get the #unparseable error. Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!