Support Board
Date/Time: Thu, 30 Oct 2025 02:21:42 +0000
Post From: Please confirm spreadsheet formula
| [2018-07-18 22:19:01] |
| Sawtooth - Posts: 4281 |
|
This will give you the average of only 2 cells, G3 and G1418: =AVERAGE_IGNOREZEROES(G3,G1418) This will give you the average of all cells from G3 to G1418 inclusive: =AVERAGE_IGNOREZEROES(G3:G1418) |