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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top