Multiplying Matrices

[Tripp]

Hello,

I have already put this formula in manually which took a while but now I'm wondering if there is a sexier alternative.

Essentially, I have a list of thicknesses (tn) and an equal number of 3x3 matrices (Mn). The number of each can change but each variables will always be of equal amounts. I wish to produce one matrix from this data.

My current formula is simply ={sum(t1*M1),(t2*M2)......} etc

This is ok but tedious when there are lots of matrices. I was wondering if there might be a better way to do this, one that involves less clicking and selecting of cells.

Regards,

Tripp

 

[Asheesh]

Hi -

On the go I can think of using sumproduct...however, if you share a sample file, people may have a better option...

 

[Tripp]

Sorry, The formula is actually {=(t1*M1)+(t2*M2)...}

The other issue is that the formula breaks down when referring to an empty cell.