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 |
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 |