Unequal Product Sum
 

I wish to multiply then add arrays of numbers of different size.

eg
array 1: A1:C1
array 2: A5:A8

where the answer equals
(A1*A5)+(A1*A6)+(A1*A7)+(A1*A7)+(A1+A8)+(B1*A5)+(B 1*A6)+......(C1*A8)

Is there a simple way to do this?

Cheers Aitchy

Unequal Product Sum
 

Hi

Try
=SUMPRODUCT(A1:C1*A5:A8)

--
Regards

Roger Govier


"Aitchy" wrote in message
...
I wish to multiply then add arrays of numbers of different size.

eg
array 1: A1:C1
array 2: A5:A8

where the answer equals
(A1*A5)+(A1*A6)+(A1*A7)+(A1*A7)+(A1+A8)+(B1*A5)+(B 1*A6)+......(C1*A8)

Is there a simple way to do this?

Cheers Aitchy

Unequal Product Sum
 

I'd just make the 2 ranges equal sized, ie A1:D1 and A5:A8
then just put a zero in D1, then array-enter (press CTRL+SHIFT+ENTER):
=MMULT(A1:D1,A5:A8)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Aitchy" wrote:
I wish to multiply then add arrays of numbers of different size.

eg
array 1: A1:C1
array 2: A5:A8

where the answer equals
(A1*A5)+(A1*A6)+(A1*A7)+(A1*A7)+(A1+A8)+(B1*A5)+(B 1*A6)+......(C1*A8)

Is there a simple way to do this?

Cheers Aitchy

Unequal Product Sum
 

Dismiss the earlier suggestion. It wasn't relevant.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---