| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
| Sumproduct | Excel Worksheet Functions | |||
| sumproduct | Excel Worksheet Functions | |||
Linear Mode
