Hi, excel novice here. I need to sum some numbers in a column, but only sum only those that match a given name in an adjacent column.
The issue is that I have a list of people with corresponding number amounts, and I need to total these amounts for each person. Since the list of people is extremely long, I would like to just be able to copy a simple formula into each cell of a new column that will sum all the numbers which have matching names in the adjacent column.See attached screen cap.
Thanks!!
Bookmarks