How many times occurs a team from column A in column D and then multiply and sum

[strooman]

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.


[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][/tr][tr][td]

1​

[/td][td="bgcolor:#0070C0"]Teams[/td][td="bgcolor:#0070C0"]Points_To-Give[/td][td="bgcolor:#0070C0"]Result[/td][td="bgcolor:#0070C0"]MyTeams[/td][/tr]
[tr][td]

2​

[/td][td]BMC Racing Team[/td][td]

20​

[/td][td]1 * 20 = 20[/td][td]BORA - hansgrohe[/td][/tr]
[tr][td]

3​

[/td][td]Team Sky[/td][td]

17​

[/td][td]1 * 17 = 17[/td][td]Team Katusha - Alpecin[/td][/tr]
[tr][td]

4​

[/td][td]Quick-Step Floors[/td][td]

14​

[/td][td]2 * 14 = 28[/td][td]UAE-Team Emirates[/td][/tr]
[tr][td]

5​

[/td][td]Mitchelton-Scott[/td][td]

11​

[/td][td][/td][td]Team Katusha - Alpecin[/td][/tr]
[tr][td]

6​

[/td][td]Team Sunweb[/td][td]

8​

[/td][td]2 * 8 = 16[/td][td]Team Sunweb[/td][/tr]
[tr][td]

7​

[/td][td]Team EF Education First-Drapac p/b Cannondale[/td][td]

5​

[/td][td]2 * 5 = 10[/td][td]Groupama - FDJ[/td][/tr]
[tr][td]

8​

[/td][td]BORA - hansgrohe[/td][td]

4​

[/td][td]2 * 4 = 8[/td][td]Team Sunweb[/td][/tr]
[tr][td]

9​

[/td][td]Astana Pro Team[/td][td]

3​

[/td][td]1 * 3 = 3[/td][td]Quick-Step Floors[/td][/tr]
[tr][td]

10​

[/td][td]Team Katusha - Alpecin[/td][td]

2​

[/td][td]2 * 2 = 4[/td][td]UAE-Team Emirates[/td][/tr]
[tr][td]

11​

[/td][td]Movistar Team[/td][td]

1​

[/td][td]1 * 1 = 1[/td][td]Team LottoNL-Jumbo[/td][/tr]
[tr][td]

12​

[/td][td][/td][td][/td][td][/td][td]Astana Pro Team[/td][/tr]
[tr][td]

13​

[/td][td]TOTAL[/td][td]Desired-Result:[/td][td="bgcolor:#FFFF00"]

107​

[/td][td]Team Dimension Data[/td][/tr]
[tr][td]

14​

[/td][td][/td][td][/td][td][/td][td]Quick-Step Floors[/td][/tr]
[tr][td]

15​

[/td][td][/td][td][/td][td][/td][td]Trek - Segafredo[/td][/tr]
[tr][td]

16​

[/td][td][/td][td][/td][td][/td][td]AG2R La Mondiale[/td][/tr]
[tr][td]

17​

[/td][td][/td][td][/td][td][/td][td]Movistar Team[/td][/tr]
[tr][td]

18​

[/td][td][/td][td][/td][td][/td][td]Lotto Soudal[/td][/tr]
[tr][td]

19​

[/td][td][/td][td][/td][td][/td][td]Team EF Education First-Drapac p/b Cannondale[/td][/tr]
[tr][td]

20​

[/td][td][/td][td][/td][td][/td][td]BMC Racing Team[/td][/tr]
[tr][td]

21​

[/td][td][/td][td][/td][td][/td][td]AG2R La Mondiale[/td][/tr]
[tr][td]

22​

[/td][td][/td][td][/td][td][/td][td]Bahrain Merida Pro Cycling Team[/td][/tr]
[tr][td]

23​

[/td][td][/td][td][/td][td][/td][td]Team Sky[/td][/tr]
[tr][td]

24​

[/td][td][/td][td][/td][td][/td][td]Team EF Education First-Drapac p/b Cannondale[/td][/tr]
[tr][td]

25​

[/td][td][/td][td][/td][td][/td][td]Team LottoNL-Jumbo[/td][/tr]
[tr][td]

26​

[/td][td][/td][td][/td][td][/td][td]BORA - hansgrohe[/td][/tr]
[tr][td]

27​

[/td][td][/td][td][/td][td][/td][td]Team Fortuneo - Samsic[/td][/tr]
[/table]

 

[sheetspread]

Excel 2010
	A	B	C
1	Teams	Points_To-Give	MyTeams
2	BMC Racing Team	20	BORA - hansgrohe
3	Team Sky	17	Team Katusha - Alpecin
4	Quick-Step Floors	14	UAE-Team Emirates
5	Mitchelton-Scott	11	Team Katusha - Alpecin
6	Team Sunweb	8	Team Sunweb
7	Team EF Education First-Drapac p/b Cannondale	5	Groupama - FDJ
8	BORA - hansgrohe	4	Team Sunweb
9	Astana Pro Team	3	Quick-Step Floors
10	Team Katusha - Alpecin	2	UAE-Team Emirates
11	Movistar Team	1	Team LottoNL-Jumbo
12			Astana Pro Team
13	TOTAL	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
Sheet5

Cell Formulas
Range	Formula
B13	=SUMPRODUCT(COUNTIF($C$2:$C$27,$A$2:$A$11),$B$2:$B$11)

 

[strooman]

Thanks for spending time in this one SheetSpread. Your solution worked perfectly. I tried first with COUNTIFS but I struggled and forgot about the SUMPRODUCT.