Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
up and down array
I need to sum (entered as array in one cell) a series of cells that go up
multiplied against a series of cells that go down. I have a row of four cells A B C D Row 1 2 5 3 6 and another row A B C D Row 3 1 2 3 4 the formula I need (my attempt at which is: =SUM(A1:D1*OFFSET(G28,0,-1*A3:D3+1)) should do the following: multiply A1*D3 multiply B1*C3 multiply C1*B3 multiply D1*A3 and sum them up. Where am I going wrong? -- Boris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
Populate an array that is a subset of a larger array? | Excel Worksheet Functions | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) |