Support Board
Date/Time: Mon, 03 Nov 2025 04:25:58 +0000
Post From: Average of non-zero values in a spreadsheet
| [2013-05-09 09:46:51] |
| Bedhog - Posts: 183 |
|
Hello All, I have an SC spreadsheet with the following 10 rows. What formula could I use to create an average of the non-zero values? 9634 9636 9638 9640 0 0 0 0 0 0 =AVERAGE(A1:A10) is returning 3854.8 when the number I really want is =AVERAGEofNonZeroValues(A1:A10) returning 9637 Thank you. |