Hi,

I have the following formula, and i need it to cover many more columns, hopefully without having to manually enter it. Here is the formula:
=(B3*$B$2)+(C3*$C$2)+(D3*$D$2)+(E3*$E$2)+(F3*$F$2) +(G3*$G$2)+(H3*$H$2)+(I3*$I$2)+(J3*$J$2)+(K3*$K$2) +(L3*$L$2)+(M3*$M$2)+(N3*$N$2)+(O3*$O$2)+(P3*$P$2) +(Q3*$Q$2)+(R3*$R$2)+(S3*$S$2)+(T3*$T$2)+(U3*$U$2)

I would like it to continue all the way to column JP, which means that the last thing that this formula will calculate will be JP3*$JP$2

(After i complete this formula i will need to drag it down a few rows, and thats why i use the $ sign.)

Is there a simple way of doing it?

Any help will be greatly appreciated. Thanks!

Hi,

Try this

=SUMPRODUCT($B$2:$JP$2,B3:JP3)

Hi,

It worked. Thanks a lot for clearing my day...