Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 29 Apr 2024 00:58:24 +0000
Post From: Please confirm spreadsheet formula
| [2018-07-18 22:19:01] |
| Sawtooth - Posts: 3982 |
|
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) |