Sumproduct

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
 
D

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)
 

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

Top