SUM function

[Dashiz]

Hello guys im having trouble doing the following:
My goal is to have =SUM(B25*E2, B24*E3, B23*E4, B22*E5, ... means that each time that I drag the column down it multiplies it for an E but oging cells upwards.

Any way to easily do this instead of manually doing everything? Thanks guys!

 

[inactiveuserps07]

@Dashiz, assuming the ranges in your example are the actual ranges, enter the following formula into F2 (or some other column in Row 2) and then drag-to-copy down to Row 25:

=E2*OFFSET(B$2,25-ROW(),0)

Then SUM() that columns values.