1 Reply Latest reply: May 16, 2012 5:37 AM by Erik Hultgren RSS

    Regarding multiplication in a row

      Hi!

       

      Lets say i have to collums in a excel file.

       

      A                     B

      500                  160

      450                  160      

      950                  160

       

      I then what i expression that multiplies (500*160+450*160+950*160)=304500

       

      I have now tested =sum(A)*sum(B) but ofc that gives me the wrong answer since it sums the row before multipling.

       

      Thanksfull for all answers!