| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum and multiply
On Sun, 25 May 2008 19:52:00 -0700, art wrote:
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? =SUMPRODUCT(A1:A2,B1:B2) --ron |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum and multiply
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? "Ron Rosenfeld" wrote: On Sun, 25 May 2008 19:52:00 -0700, art wrote: 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? =SUMPRODUCT(A1:A2,B1:B2) --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum and multiply
=SUMPRODUCT(A1:A3,B1:B3)
=SUMPRODUCT(A1:A3,C1:C3) and so on -- Regards, Peo Sjoblom "art" wrote in message ... 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? "Ron Rosenfeld" wrote: On Sun, 25 May 2008 19:52:00 -0700, art wrote: 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? =SUMPRODUCT(A1:A2,B1:B2) --ron |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum and multiply
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)) -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... =SUMPRODUCT(A1:A3,B1:B3) =SUMPRODUCT(A1:A3,C1:C3) and so on -- Regards, Peo Sjoblom "art" wrote in message ... 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? "Ron Rosenfeld" wrote: On Sun, 25 May 2008 19:52:00 -0700, art wrote: 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? =SUMPRODUCT(A1:A2,B1:B2) --ron |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum and multiply
Or maybe:
=SUMPRODUCT((A1:A3)*(B1:E3)) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Peo Sjoblom" wrote in message ... 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)) -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... =SUMPRODUCT(A1:A3,B1:B3) =SUMPRODUCT(A1:A3,C1:C3) and so on -- Regards, Peo Sjoblom "art" wrote in message ... 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? "Ron Rosenfeld" wrote: On Sun, 25 May 2008 19:52:00 -0700, art wrote: 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? =SUMPRODUCT(A1:A2,B1:B2) --ron |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum and multiply
On Sun, 25 May 2008 20:49:00 -0700, art wrote:
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:C 3), ... ) --ron |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum and multiply
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 -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "art" wrote in message ... 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? "Ron Rosenfeld" wrote: On Sun, 25 May 2008 19:52:00 -0700, art wrote: 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? =SUMPRODUCT(A1:A2,B1:B2) --ron |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum and multiply
All I want to know is how did you get your columns down the left?
Gord Dibben MS Excel MVP On Sun, 25 May 2008 20:49:00 -0700, art wrote: 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? "Ron Rosenfeld" wrote: On Sun, 25 May 2008 19:52:00 -0700, art wrote: 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? =SUMPRODUCT(A1:A2,B1:B2) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiply | Excel Discussion (Misc queries) | |||
| look up and multiply | Excel Discussion (Misc queries) | |||
| multiply, then add | Excel Discussion (Misc queries) | |||
| add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
| multiply | Excel Worksheet Functions | |||
Hybrid Mode
