Support Board
Date/Time: Tue, 21 Jan 2025 04:23:09 +0000
Post From: Please confirm spreadsheet formula
| [2018-07-18 21:17:07] |
| ForgivingComputers.com - Posts: 987 |
|
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. |