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