So lets say I have a column A of numbers from 1 to 10 and a column B of numbers from 11 to 20. Now, imagine I need to find sum of products of each number in column B with numbers in column A and put it into column S. What I mean is:
Lets, for example, take first number-11-from column B:
1×11 + 2×11 + 3×11 + … + 10×11
So, this will be the first value in column S.
So the question how to do this VBA? How to code this? Keep in mind that I`m complete newbie.