Support Board
Date/Time: Thu, 28 Nov 2024 16:34:39 +0000
Post From: Help with spreadsheet functions
| [2023-04-21 18:59:56] |
| Skipp - Posts: 6 |
|
Hi I am trying to build a spreadsheet that calculates autocorrelation however I am having issues implementing the formula required to generate it. The formula requires an average to be calculated and subtracted from numbers in a range in a SUMPRODUCT function, =SUMPRODUCT(E3:E15-AVERAGE(E3:E16), E4:E16-AVERAGE(E3:E16)). However I cannot appear to be able to get this to work in Sierra Charts spreadsheet, it works in excel fine. Do spreadsheets not support this type of function within a function? Find attached in the text doc the details output for the formula. Any help on the matter would be much appreciated.
Date Time Of Last Edit: 2023-04-21 19:01:37
|
Private File |