Sum and multiply

[art]

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?

 

[Ron Rosenfeld]

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

 

[art]

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?

 

[Peo Sjoblom]

=SUMPRODUCT(A1:A3,B1:B3)

=SUMPRODUCT(A1:A3,C1:C3)

and so on


--


Regards,


Peo Sjoblom

 

[Peo Sjoblom]

You can use this formula to get the total of all these

=SUMPRODUCT((A1:A3)*(B1:B3)+(A1:A3)*(C1:C3)+(A1:A3)*(D13)+(A1:A3)*(E1:E3))



--


Regards,


Peo Sjoblom

 

[Ron Rosenfeld]

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

 

[Bernard Liengme]

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

 

[Ragdyer]

Or maybe:

=SUMPRODUCT((A1:A3)*(B1:E3))

 

[Gord Dibben]

All I want to know is how did you get your columns down the left?


Gord Dibben MS Excel MVP