Intro Weighted Totals

This intro problem practices SUMPRODUCT. SUMPRODUCT multiplies matching positions in two ranges and then adds those products. Update the output cells so each vendor gets a weighted score based on their Cost, Speed, and Quality ratings and the weights in row 3. See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

Need help with SUMPRODUCT details and syntax? Review the SUMPRODUCT function guide first.

SUMPRODUCT
A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50