This function is does the same as the
Excel SUMPRODUCT function except on different size ranges.
Elements of the two ranges are in range1 and range2.
The numbers in range 1 to be summed are in columns that differ
by interval1. The numbers in range2 which are to be
multiplied by the numbers in range1 are in columns that differ
by interval2. The arguments start1 and start2
indicate which elements are to be summed. Examples are below
when range1 = (1, 2, 3, 4, 5, 6) and range2
= (1, 2, 3, 4)
FF_SUMPRODUCT((1, 2, 3, 4, 5,
6),(1, 2, 3, 4),3, 2, 1, 1) = 1*1 + 4*3 = 14
FF_SUMPRODUCT((1, 2, 3, 4, 5,
6),(1, 2, 3, 4),3, 2, 2, 2) =2*2 + 5*4 = 24
FF_SUMPRODUCT((1, 2, 3, 4, 5,
6),(1, 2, 3, 4),3, 2, 3, 1) = 3*1 + 6*3 = 21 |