Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I need a tricky function that I think needs to be entered as a Sumproduct Array Function. I have numerical data in a table A1:K11 (B2:K11 contains the data; A2:A11 = Row labels, B1:K1 = Column Labels) What I need to do is, given an input column (B to K) and an output column (B to K), perform the following calculation: For each cell in input column multiply by the sum of all cells below that cell's row in the output column And add the final results. So, for example, assume input column B and output column C, here's the steps I'd need to do: B2 * sum (C3:c11) + B3 * sum (C4:c11) + B4 * sum (C5:c11) + B5 * sum (C6:c11) + B6 * sum (C7:c11) + B7 * sum (C8:c11) + B8 * sum (C9:c11) + B9 * sum (C10:c11) + B10 * sum (C11:c11) Notice how the number of cells in the sum drops by 1 as you step through the input column's rows. In case it matters, the data in each column adds up to 1; the value in each cell is always greater than zero and less than 1. Is this possible? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
help please - trouble with sumproduct function | Excel Worksheet Functions | |||
Help with an array function | New Users to Excel | |||
sumproduct function | Excel Worksheet Functions | |||
Vlookups array function by Alan Beban | Excel Worksheet Functions |