Sumproduct

  • Thread starter Thread starter raj74
  • Start date Start date
R

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
 
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)
 
Back
Top