Forum Discussion

karol polubinski's avatar
karol polubinski
Brass Contributor
May 16, 2018

Multiply two rows and add all

Can anyone help me please  is there a quicker way to =I14*C14+I15*C15 in have 2500 cells to do, then i need to repeat the formula to another colomn 30 times for =J14*C14+J15*C15'  , =K14*C14+K15*C15...
excel
Formulas and Functions
karol polubinski's avatar
karol polubinski
Brass Contributor
May 17, 2018

Hi there ,

 

It really work thank you very much.

Can I ask you kindly to explain it to me sot that I can replicate it for every column please

Matt Mickle's avatar
Matt Mickle
Bronze Contributor
May 17, 2018

Karol-

 

Here is an explanation of how the sumproduct function works.  I have also attached an example file for reference.  Here is an additional link for reference:  https://support.office.com/en-us/article/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e

 

  • karol polubinski's avatar
    karol polubinski
    Brass Contributor
    May 17, 2018

    Hi there,

     

    I did understand how to edit it to go and to the work in each and every column, but I didn't understand the concept really clearly.

     

    Thank you very very much for your kind help.

    • Matt Mickle's avatar
      Matt Mickle
      Bronze Contributor
      May 17, 2018

      You're quite welcome.  Happy to help.