need to apply formula to whole rows

[jc1989]

Hello, very new to all this.

I am trying to apply a formula that I have to different rows without having to retype it every time

I am using =(C3*C2)+(D3*D2)+(E3*E2)+(F3*F2)+(G3*G2)+(H3*H2)+(I3*I2)+(J3*J2)+(K3*K2)+(L3*L2) in the N3 for a total

My titles are in row one and my price is in row 2, so starting in row 3 and going to row 50 are clients.


so the N4 would be =(C4*C2)+(D4*D2)+(E4*E2)+(F4*F2)+(G4*G2)+(H4*H2)+(I4*I2)+(J4*J2)+(K4*K2)+(L4*L2) and so on and so forth

I am trying to apply it down N column adjusting to the correct QUANTITY row without having to retype it every time.

Hope this made sense

[MrShorty]

It sound like you just need an appropriate absolute reference indicator ($) in your formula. Something like: =sumproduct($C$2:$L$2,C3:L3) note the $ that fix the row reference in the one range to row 2

Edit to add: overview of formulas including a discussion of relative absolute and mixed references: http://office.microsoft.com/en-us/ex...in=HA102749036