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.

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

 

[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.