Forum Discussion
Sigma Formula for Carbon Estimation
Hi, could someone help me to transform the attached formula to Ms. Excel? I have been trying for over 3 days, but I got a different result from the reference document.
I would recommend collecting your data together in tabular form and, provided you are using Excel 365, perform calculations as array formulas using the structured references or defined names. I picked up some of the percentage issues from your later posts but have not worked through them in detail.