Hello,

I have the following table:
A B C
Name Value1 Value 2
1 x 2 1
2 y 4 4
3 w 3 6
4 x 2 7
5 w 2 3
6 x 8 4
7 w 2 9

I need a formula to calculate sumproduct for each value in col A.
For ex: sumproduct for x should be 2*1+2*7+8*4=48
As the table is too big, i do not want to add a new column with the product of values in col B and C and then sumif. I'm hoping to find a formula to do that in a simpler way
so I could then have in a diff sheet only the sumproducts for x, y, w

Thank you