Login Page - Create Account

Support Board


Date/Time: Sat, 26 Nov 2022 23:13:01 +0000



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

[2013-05-10 12:48:48]
vegasfoster - Posts: 444
Also if you wanted to use multiple conditions, e.g. not zero and less than 500, then you could use something like

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