Repeating a formula

[Betty]

If you have a formula to multiply one cell by another plus
the remaining cells up to about 600, how do you input the
formula without having to do it manual for so many cells??

Here's a sample of the formula we have so far, but are
trying to eliminate continuing up to 600!!!

Appreciate any help!!!!!

=(B2*E2)+(B3*E3)+(B4*E4)+(B5*E5)+(B6*E6)+(B7*E7)+(B8*E8)
+(B9*E9)+(B10*E10)+(B11*E11)+(B12*E12)+(B13*E13)+(B14*E14)
+(B15*E15)+(B16*E16)+(B17*E17)+(B18*E18)+(B19*E19)+(B20*E20)
+(B21*E21)+(B22*E22)+(B23*E23)+(B24*E24)+(B25*E25)+(B26*E26)
+(B27*E27)+(B28*E28)+(B29*E29)+(B30*E30)+(B31*E31)+(B32*E32)
+(B33*E33)+(B34*E34)+(B35*E35)+(B36*E36)+(B37*E37)+(B38*E38)
+(B39*E39)+(B40*E40)+(B41*E41)+(B42*E42)+(B43*E43)+(B44*E44)
+(B45*E45)+(B46*E46)+(B47*E47)+(B48*E48)+(B49*E49)+(B50*E50)
+(B51*E51)+(B52*E52)

 

[Dan E]

Betty,

Not a repeating formula, but perhaps more suited to your
situation is the SUMPRODUCT formula (Sum of the products)

=SUMPRODUCT(B2:B600, E2:E600)

Dan E

 

[jaf]

Hi Betty,
=sumproduct(b2:b601,e2:e601) assumes 600 rows.

 

[Roland De Bouvere]

That's far from efficient indeed. Create a column e.g. F that holds the
result of one multiplication and then you're formula will look like
SUM(F2:F600). You can hide that column if you wish.