Sumproduct
 

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

Sumproduct
 

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

Sumproduct
 

Sure, you can just subtract the constant from the array, Excel is smart
enough to know you want that subtracted from every cell in the range:
=SUMPRODUCT(A1:A15,B1:B15-E1)

--
Regards,
Dave


"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