I have a table with two rows - a person's name and points. I'm looking to create a third column that uses an Arrayformula to match the name in column A and sum up the points for that person across all of column B.
A and B are static (with new entries added to the bottom) so I'm looking for the formula to use in column C.
| Name | Points | Person's Total Points |
|---|---|---|
| John Smith | 1. | 1.25 |
| Ellen Dee | 0.5 | 0.5 |
| Jerry Lewis | 2 | 3 |
| John Smith | 0.25 | 1.25 |
| Jerry Lewis | 1 | 3 |
Here is a sample spreadsheet:
