• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SIGMA of Arrays and Cells

T

Tripp

Member
Hey,

I'm trying to perform this formula within excel and currently I am trying in each individual component. I have attempted using sum product and helper columns but the combination of arrays and single cells seems to be throwing the calculations.


upload_2014-11-11_18-24-46.png


I have a list of [Q], tk & tzk values but as of right now, I cant find a good way to calculate the D matrix, other than typing each calculation seperately. (All matrices are 3x3)

Any ideas?

Regards,

Tripp
 
Tripp

What is the function called/doing ?

can you post a file with example data so we can see what your against
 
You must log in or register to reply here.
Back
Top