Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 10:36:31 +0000



Post From: Average of non-zero values in a spreadsheet

[2013-05-09 09:46:51]
Bedhog - Posts: 165
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.