Support Board
Date/Time: Sun, 06 Jul 2025 17:06:51 +0000
Post From: Spreadsheet study average of zig zag line length
| [2020-02-13 14:12:39] |
| grantx - Posts: 244 |
|
The zigzag study shows me the length of each swing. I can see these numbers plotted in the spreadsheet study in the AF column. I want to get an average of the last 10 swings. The problem is that there are a lot of zeros before a new swing prints. See attached. How do I create a formula to put into the K column, which only gives me an average of numbers that are not zero? I just want a single cell to display the average and not copied down the entire spreadsheet. |
1.png