Conditional product

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.

will this macro help you

Please Login or Register  to view this content.

This maby?

Please Login or Register  to view this content.