Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010
    Posts
    30

    Unanswered: Complicated SUM formula

    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!

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,

    Try this

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

  3. #3
    Join Date
    Mar 2010
    Posts
    30
    Hi,

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •