How iterate over some range of values and find sum of products?

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.

submitted by /u/oqowa
[link] [comments]

Leave a Reply