Spreadsheet: 692022d1598019059-help-to-sum-duplicates-ny-prob-3-excel-amarella82-
Sheet: Solution 1

name | office | team | leads | p | e | r | t | t | t | t | t | t | t | t | Helper |  |  | Totalt |  |  |  |  |  | Nova |  |  |  | Nova | Team 4 |  | Nova | Team 7 |  | Nova | Team 31 |  | Nova | Team 40 |  |  | [NAME] |  |  |  | [NAME] | Lands |  |  | Region Stockholm |  |  |  | Region Stockholm | Brommaplan |  | Region Stockholm | [NAME] |  | Etc…
[EMAIL] | [NAME] | Lands | 73 | 47 | 26 | 1 | 7 | 2 | 11974 | 20 | 3 | 0 | 2 | 9
[EMAIL] | Nova | Team 7 | 66 | 66 | 0 | 61 | 0 | 3 | 1190 | 20 | 0 | 1 | 1 | 3 |  |  |  | Rådgivare | Region | Team/Kontor | Förmedlade kunder |  |  | Rådgivare | Region | Förmedlade kunder |  | Rådgivare | Förmedlade kunder |  | Rådgivare | Förmedlade kunder |  | Rådgivare | Förmedlade kunder |  | Rådgivare | Förmedlade kunder |  |  | Rådgivare | Kontor | Förmedlade kunder |  | Rådgivare | Förmedlade kunder |  |  | Rådgivare | Kontor | Förmedlade kunder |  | Rådgivare | Förmedlade kunder |  | Rådgivare | Förmedlade kunder
[EMAIL] | Nova | Team 31 | 52 | 18 | 34 | 18 | 1 | 3 | 13571 | 12 | 3 | 0 | 1 | 4
[EMAIL] | Nova | Team 31 | 41 | 11 | 30 | 2 | 2 | 2 | 0 | 7 | 0 | 1 | 0 | 2 |  |  |  | [NAME] | [NAME] | Lands | 73 |  |  | [NAME] | Team 31 | 27 |  | Ebba Nystrom | 35 |  | Firm Far | 66 |  | [NAME] | 27 |  | [NAME] | 29 |  |  | [NAME] | Lands | 73 |  | [NAME] | 73 |  |  | [NAME] Jos | Brommaplan | 29 |  | [NAME] Jos | 29 |  | [NAME] | 27
[EMAIL] | Nova | Team 31 | 39 | 9 | 30 | 0 | 3 | 0 | 0 | 3 | 0 | 0 | 0 | 3 |  |  |  | Firm Far | Nova | Team 7 | 66 |  |  | [NAME] | Team 38 | 33 |  |  |  |  | Hel Taf | 35 |  |  |  |  |  |  |  |  | [NAME] | Lands | 29 |  | [NAME] | 29 |  |  | [NAME] | [NAME] | 27
[EMAIL] | Nova | Team 4 | 35 | 35 | 0 | 27 | 4 | 4 | 16207 | 19 | 3 | 4 | 2 | 6 |  |  |  | Ebba Nystrom | Nova | Team 4 | 35 |  |  | Ebba Nystrom | Team 4 | 35 |  |  |  |  | [NAME] | 24
[EMAIL] | Nova | Team 7 | 35 | 35 | 0 | 31 | 1 | 1 | 1795 | 16 | 1 | 1 | 0 | 2 |  |  |  | Hel Taf | Nova | Team 7 | 35 |  |  | [NAME] | Team 40 | 29
[EMAIL] | Nova | Team 38 | 33 | 33 | 0 | 1 | 6 | 3 | 12979 | 10 | 2 | 1 | 2 | 8 |  |  |  | [NAME] | Nova | Team 38 | 33 |  |  | Firm Far | Team 7 | 66
[EMAIL] | Region Stockholm | Brommaplan | 29 | 3 | 26 | 1 | 4 | 5 | 9576 | 12 | 2 | 1 | 1 | 7 |  |  |  | [NAME] Jos | Region Stockholm | Brommaplan | 29 |  |  | Hel Taf | Team 7 | 35
[EMAIL] | [NAME] | Lands | 29 | 28 | 1 | 25 | 3 | 2 | 8784 | 20 | 1 | 0 | 1 | 3 |  |  |  | [NAME] | [NAME] | Lands | 29 |  |  | [NAME] | Team 7 | 24
[EMAIL] | Nova | Team 40 | 29 | 0 | 29 | 0 | 3 | 2 | 7979 | 4 | 2 | 0 | 2 | 4 |  |  |  | [NAME] | Nova | Team 40 | 29
[EMAIL] | Region Norr | Uppsala | 28 | 28 | 0 | 17 | 1 | 8 | 11971 | 18 | 2 | 3 | 1 | 6 |  |  |  | Per A Lars | Region Norr | Uppsala | 28
[EMAIL] | Region Stockholm | [NAME] | 27 | 3 | 24 | 1 | 2 | 2 | 7584 | 3 | 2 | 0 | 1 | 3 |  |  |  | [NAME] | Region Stockholm | [NAME] | 27
[EMAIL] | Nova | Team 31 | 27 | 15 | 12 | 1 | 5 | 1 | 5592 | 7 | 1 | 0 | 1 | 5 |  |  |  | [NAME] | Nova | Team 31 | 27
[EMAIL] | Region Stockholm | Norrmalm | 26 | 20 | 6 | 13 | 2 | 7 | 9412 | 11 | 2 | 3 | 1 | 5 |  |  |  | [NAME] | Region Stockholm | Norrmalm | 26
[EMAIL] | Nova | Team 7 | 24 | 4 | 20 | 3 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 1 |  |  |  | [NAME] | Nova | Team 7 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | office | Nova
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | team | Team 4 |  | office | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | office | Nova |  |  | Helper | Sum of leads |  | Helper | team | Sum of leads
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ebba Nystrom | 35 |  | [NAME] | Lands | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helper | office | team | Sum of leads |  |  | Helper | team | Sum of leads |  | Grand Total | 35 |  | [NAME] | Lands | 73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Lands | 73 |  |  | [NAME] | Team 7 | 24 |  |  |  |  | Grand Total |  | 102
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Firm Far | Nova | Team 7 | 66 |  |  | Ebba Nystrom | Team 4 | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hel Taf | Nova | Team 7 | 35 |  |  | [NAME] | Team 31 | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ebba Nystrom | Nova | Team 4 | 35 |  |  | Firm Far | Team 7 | 66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Nova | Team 38 | 33 |  |  | Hel Taf | Team 7 | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Lands | 29 |  |  | [NAME] | Team 40 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Nova | Team 40 | 29 |  |  | [NAME] | Team 38 | 33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Region Stockholm | Brommaplan | 29 |  |  | Grand Total |  | 249
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per A.Lars | Region Norr | Uppsala | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Region Stockholm | [NAME] | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Nova | Team 31 | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Region Stockholm | Norrmalm | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Nova | Team 7 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  | 461