Sumproduct

[raj74]

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

 

[Paul]

=sumproduct(a1:a15*(b1:b15-$e$1))

 

[Paul J.]

Try:

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

 

[David Billigmeier]

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)

 

[raj74]

Paul, David
Thanks a lot.

Regards!!!!!!!

Rajarshi