I have an excel table that in column A is a list of names that DO occassionally repeat. In column B is a number.
I need a function that looks up column A for a specific name, like "Wendy," and every time that name occurs, find the value in the same row in column B and sums all those occurances together, displaying the result.
For example, if "Wendy" appeared four times, once next to the number 20, then 26, then 42, then 7, the result should be 95.
The names are not grouped and cannot be rearranged.
Thank you for the help.
Bookmarks