I want to know if this is possible with one formula in C13.
This is the scenario.
How many times occurs a team from column A in Column D and then multiply with the points in column B.
Column C is just the intermediate step for clarity. End result is in C13 where the formula comes.
This is the scenario.
How many times occurs a team from column A in Column D and then multiply with the points in column B.
Column C is just the intermediate step for clarity. End result is in C13 where the formula comes.
Row\Col | A | B | C | D |
1 | Teams | Points_To-Give | Result | MyTeams |
2 | BMC Racing Team | 20 | 1 * 20 = 20 | BORA - hansgrohe |
3 | Team Sky | 17 | 1 * 17 = 17 | Team Katusha - Alpecin |
4 | Quick-Step Floors | 14 | 2 * 14 = 28 | UAE-Team Emirates |
5 | Mitchelton-Scott | 11 | Team Katusha - Alpecin | |
6 | Team Sunweb | 8 | 2 * 8 = 16 | Team Sunweb |
7 | Team EF Education First-Drapac p/b Cannondale | 5 | 2 * 5 = 10 | Groupama - FDJ |
8 | BORA - hansgrohe | 4 | 2 * 4 = 8 | Team Sunweb |
9 | Astana Pro Team | 3 | 1 * 3 = 3 | Quick-Step Floors |
10 | Team Katusha - Alpecin | 2 | 2 * 2 = 4 | UAE-Team Emirates |
11 | Movistar Team | 1 | 1 * 1 = 1 | Team LottoNL-Jumbo |
12 | Astana Pro Team | |||
13 | TOTAL | Desired-Result: | 107 | Team Dimension Data |
14 | Quick-Step Floors | |||
15 | Trek - Segafredo | |||
16 | AG2R La Mondiale | |||
17 | Movistar Team | |||
18 | Lotto Soudal | |||
19 | Team EF Education First-Drapac p/b Cannondale | |||
20 | BMC Racing Team | |||
21 | AG2R La Mondiale | |||
22 | Bahrain Merida Pro Cycling Team | |||
23 | Team Sky | |||
24 | Team EF Education First-Drapac p/b Cannondale | |||
25 | Team LottoNL-Jumbo | |||
26 | BORA - hansgrohe | |||
27 | Team Fortuneo - Samsic |