Multiplying Arrays
Thanks very much.
"Dana DeLouis" wrote:
Thanks v much. Is it possible to achieve the same result without using an
array formula ...?
=MMULT(Horizontal, Vertical)
--
HTH :)
Dana DeLouis
"Phil H" wrote in message ...
Peo,
Thanks v much. Is it possible to achieve the same result without using an
array formula as the requirement to achieve this is part of a much wider
formula that does not need to be entered as an array formula.
Thanks.
"Peo Sjoblom" wrote:
Try
=SUMPRODUCT(G2:G4,TRANSPOSE(H1:J1))
entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
"Phil H" wrote in message
...
I understand that it is possible to multiply two arrays using SUMPRODUCT().
How can this be achieved if the orientation of the two arrays is
different.
For example, if three cells in a horizintal row with values 10% : 50% and
40%
are intended to be mutiplied in turn by three cells in a vertical column
with
values of 3% : 4% and 5%.
When I try this I get the answer 12% and Excel will not allow the use of
TRANSPOSE() to change the orientation of one of the arrays within the
SUMPRODUCT.
Thanks,
|