Hi Excel forum,

I'm a relatively newbie user trying to do the following:

Multiply each value in A1:20 by each value in B1:20 and sum them all, EXCEPT for A1*B1, A2*B2, etc. Such that we have A1*B2 + A1*B3 +...+ A2*B1 + A2*B3 +...

I imagine it's a simple fix I can't figure out how to do it for the life of me using array functions >_< Will I have to get into the VBA code? I have yet to explore that realm..

Thanks in advance.