Support Board
Date/Time: Fri, 26 Jun 2026 18:39:41 +0000
Post From: Please confirm spreadsheet formula
| [2018-07-18 22:19:01] |
| Sawtooth - Posts: 4335 |
|
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) |