Hi there,
I am rather new to that, so excuse me if I am asking simple stuff ;-)
I have an excel sheet which contains 3 columns: A, B and C.
A = Contains an internal Name (it's kind of unimportant for my question)
B = Contains a number value
C = Contains the name of a person
Important are columns B and C.
I have a pool of roundabout 12 different Person names that can appear in column C.
Example:
Column A | Column B | Column C
Internal1 | 23 | Peter
Internal2 | 11 | Mary
Internal1 | 55 | Peter
Internalx | 2 | Frank
InternalT | 32 | Mary
You can see that the persons can appear more than once in column C. To the left of each name I have a number value.
My Goal: I need a formula that will go through the whole column C and lookup each name and count (SUM) the number value to the left hand side of this name.
So, based on above example, it should look like:
Peter | 78
Mary | 43
Frank | 2
The formula found Peter's name twice in column C and found the numbers 23 and 55 and made the SUM of it, which is 78.
The formula found Mary's name also twice in column C and found the numbers 32 and 11 and made the SUM of it, which is 43
The formula found Frank's name only once in Column C and found the the value 2, so the result is still 2.
This all should be residing in a different sheet of the same workbook.
I am adding up every week a new sheet with the same kind of list, but different number values in column B.
I want to have a separate sheet at the end of the workbook, which looks it up in the different sheets.
However, this is less important. If I find the right formula to get the numbers out of one sheet, that is good enough to start with.
Any idea?
What I managed to do is finding the value in the column (field) next to a specific entry. But I am struggling with going into loop and finding further occurrences and summing them up.
I was using this:
LOOKUP("Mary", C1:C999, B1:B999)
This would lookup Mary and when found, give me the value from the column to the left of it.
Any help is greatly appreciated!
Bookmarks