TRANSPOSE and MMULT don't work together

[Guest]

Hi,

I found that TRANSPOSE and MMULT do not work together well. if I type the
following I get #VALUE!.

=MMULT(A1:C1,TRANSPOSE(A2:C2))

where A1:C1 and A2:C2 are two 3*1 vectors of numbers.

However, through trial and error, I find if I type in the above formula as
an array formula (by pressing CTRL-SHIFT-ENTER), although the 'array formula'
takes only one cell, it actually works.

Can anyone let me know why this would be the case? Anyway to type the
formula in as a regular formula?

Thanks,
Geoffrey

 

[Guest]

I apologize for so many duplicated posts. I was re-posting only because
MSDN's web interface was telling me that the action failed.

 

[hgrove]

Geoffrey Zhu wrote...

I found that TRANSPOSE and MMULT do not work together well.
if I type the following I get #VALUE!.

=MMULT(A1:C1,TRANSPOSE(A2:C2))

...

Technically, this has nothing to do with MMULT, everything to do wit
TRANSPOSE. Unless you're passing TRANSPOSE an array constant, yo
*MUST* enter formulas calling it as array formulas