Support Board
Date/Time: Tue, 01 Jul 2025 05:51:13 +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)) |