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