 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Sum and multiply
Hello: I have in row A for E.G. amounts, lets say: A 3 6 4 B 2.00 3.00 2.50 Is there an easier way to calculate all together. The long way is =(A1*B1)+(A2*B2)..., is there a shorter way to write this calculation? >Hello: > [quoted text clipped - 4 lines] >Is there an easier way to calculate all together. The long way is >=(A1*B1)+(A2*B2)..., is there a shorter way to write this calculation? =SUMPRODUCT(A1:A2,B1:B2) --ron My qustion is more like this: A 3 6 4 B 2.00 3.00 2.50 SUMtotal (B1*A1)+(B2*A2)+(B3*A3) C 3.50 4.00 5.00 SUMtotal (C1*A1)+(C2*A2)+(C3*A3) D 7.00 1.00 1.45 SUMtotal (D1*A1)+(D2*A2)+(D3*A3) E 1.65 3.50 3.00 SUMtotal (E1*A1)+(E2*A2)+(E3*A3) How do I do it shorter? > >Hello: > > [quoted text clipped - 8 lines] > > --ron =SUMPRODUCT(A1:A3,B1:B3) =SUMPRODUCT(A1:A3,C1:C3) and so on  SignatureRegards, Peo Sjoblom > My qustion is more like this: > [quoted text clipped - 18 lines] >> >> --ron You can use this formula to get the total of all these =SUMPRODUCT((A1:A3)*(B1:B3)+(A1:A3)*(C1:C3)+(A1:A3)*(D1:D3)+(A1:A3)*(E1:E3)) SignatureRegards, Peo Sjoblom > =SUMPRODUCT(A1:A3,B1:B3) > [quoted text clipped - 24 lines] >>> >>> --ron Or maybe: =SUMPRODUCT((A1:A3)*(B1:E3)) SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > You can use this formula to get the total of all these =SUMPRODUCT((A1:A3)*(B1:B3)+(A1:A3)*(C1:C3)+(A1:A3)*(D1:D3)+(A1:A3)*(E1:E3)) > > =SUMPRODUCT(A1:A3,B1:B3) > > [quoted text clipped - 24 lines] > >>> > >>> --ron >A 3 6 4 >B 2.00 3.00 2.50 SUMtotal (B1*A1)+(B2*A2)+(B3*A3) =SUMPRODUCT(A1:A3,B1:B3) >C 3.50 4.00 5.00 SUMtotal (C1*A1)+(C2*A2)+(C3*A3) =SUMPRODUCT(A1:A3,C1:C3) etc. or, to add them all up: =SUM(SUMPRODUCT(A1:A3,B1:B3),SUMPRODUCT(A1:A3,C1:C3), ... ) --ron I am reading this differently to other repliers In the first formula =SUMPRODUCT($A$1:$A$3, B1:B3) Now when you copy it dwn, the referecne to A stays the same best wishes SignatureBernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme > My qustion is more like this: > [quoted text clipped - 18 lines] >> >> --ron All I want to know is how did you get your columns down the left? Gord Dibben MS Excel MVP >My qustion is more like this: > [quoted text clipped - 18 lines] >> >> --ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.