Help with Sigma fuction

[Zalachenko]

Hi, i need help with writing out a sigma function (Sum fuction)

Equation is in attachments

Thanks!

[MrShorty]

It appears that this equation will start with n and t matrices (or vectors). The first term is a SUMPRODUCT() of the n and t matrices (or a subset of the n and t matrices). The second term is also a SUMPRODUCT(), but you are adding to portions of the t matrix together before the SUMPRODUCT(). Assuming you know how to set up the matrices/vectors, I would expect the final formula to be =$A$1*(SUMPRODUCT(n matrix/vector,t matrix/vector)+SUMPRODUCT(n matrix/vector,sum of t matrix/vectors)) where A1 contains the value for C.

[Zalachenko]

Thanks, but its not matrices its a equation for preventive maintenance for machines.
i made it shorter but heres the whole equation, tanks!

[Zalachenko]

Cp is personel costs and np is amout of personel and the other ones are the time it takes to do difrent operations

[MrShorty]

You may need to upload a sample (complete with a worked up result), because I am unable to visualize what this equation is doing without some kind of matrix of n and t values. Maybe it is the words "matrix" or "vector" that are confusing us? Call it what you want (lists of n and t values? sequences of values? I don't know). Whatever you want to call the n and t values, this equation looks to me like the sum of two SUMPRODUCT()'s multiplied by a scaling factor. As long as you know how to get or calculate the n and t values, that's what I see for this equation.

Of course, if your question is really about getting or calculating n and t, then we need more information about those variables.