Is SUMPRODUCT the right formula here?

[ViperStripes]

I've got 2 columns that I want to sum each row first then multiply by the same factor for each row. e.g

​	A​	B​	C​
1	£4	-£3	300
2	£4.25	-£3	300
3	£4.72	-£3	300
4	£4.96	-£3	300
	TOTAL:​	£1,779

So I'm trying to do (A+B)x300 for each Row then Sum the total of each row. So the answer to the above would be (£1+£1.25+£1.72+£1.96)x300 = £1779

Column C will always be the same figure all the way down. So don't even really need Col C, could just be a single cell anywhere on the sheet, would like to do away with it really.

I thought SUMPRODUCT with some tweaks or embedded other function within the brackets might work, but can't seem to work it out.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1
2	£4	-£3	300
3	£4.25	-£3	300
4	£4.72	-£3	300
5	£4.96	-£3	300
6	TOTAL:	£1,779
Sheet5

Cell Formulas
Range	Formula
B6	B6	=SUM(A2:B5)*C2

 

[ViperStripes]

Thank you, so obiously simple, was overthinking it completely. Wood trees and all that!

 

[Fluff]

You're welcome & thanks for the feedback.