Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 02 Dec 2023 09:07:08 +0000

How to Post a Message for Support

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

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

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