Hello,
I am having trouble finding the correct function to combine data on a spreadsheet I'm working on (attached). Essentially, I have data in column A with names, many of which occur several times throughout the column. However, each row has a specific numerical value in column B. I am trying to consolidate the data by combining rows with similar names but summing the numerical values. For example:
Name, Value
A, 3
A, 2
A, 7
B, 4
C, 11
C, 6
Becomes...
Name, Value
A, 12
B, 4
C, 17
If someone could help me out with the function and how to complete it, that would be greatly appreciated.
Cheers,
chandy
Bookmarks