Hi,
I am really in a big muddle and any help would be very much appreciated.
I have a list containing an average of evaluations scores, some of the individuals may have 2 or more units in column A and the Score in Column B is the average of the evaluations. All this is OK but when I want to calculate the Score for the hierarchy it becomes difficult as the list contains more than one manager, so I do need help to build a formula where I can calculate the overall score for Joe Blogs team, the example below:
As a result I want to have the score for User ID (147386) and in Week 6 only, if I do a straight SUMPRODUCT as SUMPRODUCT(A2:A7*B2:B7)/SUM(A2:A7) would give me a score of 60.56 great… no issues but my list contains more than 1 user and more than 1 week…
Thanks,