I have 2 columns, “A” contains a name and “B” contains a value. Some of the names in “A” are repeated. If they are repeated in “A” I need the sum of there “B” values. So for example
“A” “B”
Bob 10
Sam 4
Bob 5
Joe 6
Fred 9
I need to know that Bob is 15, Sam is 4, Joe is 6, and Fred is 9. There are about 3000 rows and the data will change in the future so doing it manually will be time consuming. Is there a function that can do this fo me?
Bookmarks