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
1	Item	Price	Small	Medium	Large	Total $
2	A	$10	1	2	3	$60
3	B	$20	4	5	6	$300
4	C	$20	2	1	5	$160
5						$520	$520

<tbody>
</tbody>