The result for the ranges shown should be a single cell. But as you state,
it still needs to be array entered.
1 x 18 against 18 x 18 gives 1 x 18 against (transpose 1 x 18)
gives a 1 x 1
--
Regards,
Tom Ogilvy


"tomhaddock" wrote in message
...
Hi

highlight the range you want the matrix to be in so if my matrix is 3x3
then I would highlight the matrix A1:C3. Then enter the matrix formula
and then hold down CRTL-Shift and press enter. This should fill in the
whole matrix with the formula you entered.

Hope this works... its been a while since I used MMULT().

Tom



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/