Support Board
Date/Time: Fri, 22 Nov 2024 13:40:46 +0000
Post From: Average of non-zero values in a spreadsheet
| [2013-05-09 09:46:51] |
| Bedhog - Posts: 179 |
|
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. |