Login Page - Create Account

Support Board


Date/Time: Sat, 26 Nov 2022 23:11:47 +0000



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

[2013-05-10 12:38:46]
vegasfoster - Posts: 444
If you want to put it in a single formula, you can use

=SUM(A1:A10)/SUMPRODUCT(--(A1:A10<>0))