Support Board
Date/Time: Fri, 04 Jul 2025 09:48:23 +0000
Post From: Please confirm spreadsheet formula
| [2018-07-18 22:19:01] |
| Sawtooth - Posts: 4231 |
|
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) |