| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use SumProduct with a horizonontal and vertical array?
With the SumProduct formula, the arrays must have the same dimensions. So how
can I use it when I want to sum the product of a horizontal row of data and a vertical column of data? I've tried messing around with the Transpose function but I can't get it to work with SumProduct. |
Threaded Mode
