Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Wondering if there is a way to use an array formula for this?
I'm trying to multiply data for several months (data arranged in columns) by values contained in one column. In the example below I want to multiply .5 by 100, 125 and 75, .7 by 100, 125 and 75, etc. Then take the sum of these products. I was thinking {sum(b1:d6*a2:a6)} would work, but it returns an error. Multiplier Jan Feb Mar 0.5 100 125 75 0.7 100 125 75 0.9 100 125 75 0.4 100 125 75 0.3 100 125 75 Any help on this is greatly appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
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) | |||
How to multiply all cells in array by factor | Excel Discussion (Misc queries) |