I've got in column A a series of names, ex. A1="Fred", A2="Jos", A3="John" and so on. In column B next to the names I've got a value, B1=236.69, B2=254.87, B3=326.99,...
Here's my problem, the names in column A may repeat themselves. I need a way to match the names in Column A to the values in column B and find the total value that is in column B that matches with the specific name in column A.
Here's an example:
I've got 3 instances of "Mark" in column A with corresponding values in column B of 10.00, 5.00 and 15.00. At the bottom of my sheet I've got to show that Mark has a total of 30.
Can anyone help?
Here's my problem, the names in column A may repeat themselves. I need a way to match the names in Column A to the values in column B and find the total value that is in column B that matches with the specific name in column A.
Here's an example:
I've got 3 instances of "Mark" in column A with corresponding values in column B of 10.00, 5.00 and 15.00. At the bottom of my sheet I've got to show that Mark has a total of 30.
Can anyone help?