Try:

=SUMPRODUCT(A1:A15*(B1:B15-$E$1))


"raj74" wrote:

Hello!!

I want to sumproduct for 2 vert. array (A1:A15 & B1:B15) but with a slight
modification. While doing the sumproduct, i want the a const value say
representing cell E1 will be subtracted from each value of array 2 and then
multiply with the array 1 & finaly the addup of all multiplicated values.
Can it be possible in excel.
Regards