Unequal Product Sum

[Aitchy]

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)+(B1*A6)+......(C1*A8)

Is there a simple way to do this?

Cheers Aitchy

 

[Roger Govier]

Hi

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

 

[Max]

I'd just make the 2 ranges equal sized, ie A11 and A5:A8
then just put a zero in D1, then array-enter (press CTRL+SHIFT+ENTER):
=MMULT(A11,A5:A8)

 

[Max]

Dismiss the earlier suggestion. It wasn't relevant.