Help translate math formula into excel format!

[DanielR]

Hello. I have absolutely no clue how to transform the attached mathematical formula into excel format syntax. Please help!

 

[Harry_the_cat]

Do you have 21 numbers in each of columns A, B, C and D? Or do you know what A1, A2, etc are?

Also, what is M?

 

[DanielR]

Yes there are 21 numbers in all variables, like columns of values, except M that is a static variable.

 

[JeffM]

Hello. I have absolutely no clue how to transform the attached mathematical formula into excel format syntax. Please help!

\(\displaystyle \Sigma\) is the capital letter sigma in the Greek alphabet. It is equivalent to S in the English alphabet and means to sum. You can use the SUM function in excel to translate sigma notation into excel.

 

[Harry_the_cat]

Yes there are 21 numbers in all variables, like columns of values, except M that is a static variable.

Ok, I would set up two extra columns: AB (fill with the products A*B for each k ) and CD. Then use Sum function in Excel as JeffM said to find the sums of columns B, D, AB and CD. Then you can apply your formula to calculate I.