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

    Regarding multiplication in a row



      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!