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.
Bookmarks