Repeating a formula

  • Thread starter Thread starter Betty
  • Start date Start date
B

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)
 
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
 
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.
 
Back
Top