Summing Across Tables

[psuedodragon]

I'm sorry if this question has been asked before--I'm not quite sure how to search for it.

I need to get the sum of a series of multiplications, but don't want to have to write them out line by line.

An example of the data being worked with:

So the only thing I can think of is to do =(SUM(F2:Q2)*E2)+(SUM(F3:Q3)*E3)+...etc.

But as there are hundreds of lines I would prefer to not have to write it out like that. Are there any functions that will 'automate' this for me?

Thank you in advance

 

[StephenCrump]

I suggest it would be clearer to use a helper column:

F2: =B2*SUM(C2:E2) Copy the formula down the column.

Or in one go:

G5: =SUMPRODUCT(B2:B4*C2:E4)

	A	B	C	D	E	F	G
Item
A
B
C

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]Price[/TD]
[TD="align: right"]Small[/TD]
[TD="align: right"]Medium[/TD]
[TD="align: right"]Large[/TD]
[TD="align: right"]Total $[/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]$10[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]$60[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]$20[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]$300[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]$20[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]$160[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$520[/TD]
[TD="align: right"]$520[/TD]

</tbody>