Apple Event: May 7th at 7 am PT

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

9 points

Advanced Math (Matrix * Vector)

Hello.

In Numbers (iWork '08), is there any way to calculate the elements resulting from multiplying a Matrix (square table) to a Vector (single-column table) in another Vector (single-column table)?

I'm currently multiplying term by term, but it's a pain for lots of data. There must be a smarter way to do that.

Numbers '08-OTHER, Mac OS X (10.7.3)

Posted on May 8, 2012 1:35 PM

Best reply

Jerrold Green1

Level 7

30,211 points

Posted on May 8, 2012 2:02 PM

Numbers doesn't support Matrix math, not in either Numbers 08 or Numbers 09.

Jerry

View in context

16 replies

MVittiS Author

Level 1

9 points

May 8, 2012 8:12 PM in response to Wayne Contello

Now that's the formula I was looking for!!

I didn't knew the correct usage of SUMPRODUCT() (and also didn't knew of TRANSPOSE()'s existence), but now it's a complete, copy-paste-able, one-liner.

Thank you very much, WC.

Advanced Math (Matrix * Vector)

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple ID.

Learn more Sign up