Support Board

Date/Time: Mon, 29 Apr 2024 00:25:44 +0000

Post From: Please confirm spreadsheet formula

[2018-07-18 21:17:07] Link To Thread - Link To Post [Go To First Post]
bradh - Posts: 854
Yes, that is the correct formula, however it will need an = sign in front of it. Normally spreadsheet formulas go in row 3 of columns K-Z (or higher if you add more columns in the study inputs), which represents the current bar. Row 4 is the one before that, etc. If you put it in row 3 of one of the columns K-Z, it will copy itself down to the last row, modifying the numbers, so if: K3: =AVERAGE_IGNOREZEROES(G3,G1418) K4: =AVERAGE_IGNOREZEROES(G4,G1419) K5: =AVERAGE_IGNOREZEROES(G5,G1420) etc. If you don't want it to do that, then put a $ in front of the row number: =AVERAGE_IGNOREZEROES(G$3,G$1418) If only need the formula once, and you don't need one per row, you can use any cell in Column H to hold the formula.